Complete DAX Course - From Basics to the Advanced Level | DAX Tutorial | BI Consulting Pro| Power BI

[@BIConsultingPro]

You can download all the demo files from here: github.com/ajaysharma2061/DAX-Sundays

[@santoshdevtale]

Thank you for this video

[@Lolguyj]

Hi, it would be nice if you specified which files are used in each section of the video, I'm stuck on filter propagation as the file shared for filter propogation is not the same as in the video.

[@mahadevshah3099]

This is awesome, it would be more helpful if you could share the supporting file.

[@BIConsultingPro]

All files are here: github.com/ajaysharma2061/DAX-Sundays

[@DexterDialytic9nik]

The video and contain is properly aligned but it would be better if ur voice clear and smooth. Thank u very much....

[@gillojunkumar]

Hi Bro, I have a real time challenge in preparing a report. 1. i want to find the count of live Marketing people based on before date slicer or max date or irrespective of between dates slicer 2. Based on the above i want to find per person quantum of sale. 3. How to create start date and end date slicer for a report / for an direct query 4. Can we create report in Paginated reports? Because all these we are used to create Tableau report. Now we are planning to migrate to Power BI.

[@BIConsultingPro]

Thanks for your query. I'll check this, and will get back to you.

[@HappyLandTravel]

Thanks for making this video. It's so helpful!

[@BIConsultingPro]

Glad it was helpful!

[@sapna1-2024]

Hello Ajay. So glad to find this. Need help on running total DAX

[@BIConsultingPro]

Hey! Glad to hear from you! Please connect with me at [e-mail]. Also, send me your query there

[@pauloleal3376]

Great! There are some files that I didn't find, like MAX and MIN or Calculate file.

[@harshadavichare3120]

Sir your explanation is great but when you show the types of function it doesn't seem clear

[@BIConsultingPro]

Sorry for that! We will try our best to clarify in detail in the future. However, if you have any specific query, kindly let us know. We appreciate your time, and visiting our channel.

[@mahadevshah3099]

This is humble request if you can share the .pbix file for practice.

[@BIConsultingPro]

Please download from here: github.com/ajaysharma2061/DAX-Sundays. I have also provided the link in the description section

[@mohammadaamirkhan7830]

Hi Sir, Thank you for marking this video. However, I can't see SUMMARIZE DAX in the list of video. Could you please make a tutorial on this?

[@BIConsultingPro]

We already have a video on that too…. Please check on DAX Sundays playlist

[@BIConsultingPro]

kzbin.info/www/bejne/q6CQnIaKqaqpgMU

[@manohara3060]

How do we use Max with if condition. If A column one row value is equal Max of A value else if Max-1 Value

[@BIConsultingPro]

Hi there, sorry for the delayed response. I didn't get a chance to look into this. Once, I'll get sometime, I'll reply you.

[@kemelewf1531]

You did demo. but the background classical music is very distractive

[@vikassinghjayara510]

Thank you sir. This is an awesome to be learning DAX with you. Request you please make one video on PowerBI service as well.

[@RavinderKumar-gl8cy]

Sir, I am having the data of sales amount having the column State and District. I have created a measure for total sales. and created 2 Slicer i.e. State and District and I have sync slicer for all the pages of the report. I have created a table with column State and Sale. If I don't selected any slicer from state then default value should be State Column and Sale Column and If I select any state the respective district of the state should come i.e. District column in place of State Column and Sale column. Please advise sir, how it can be done.

[@BIConsultingPro]

3. Create a Table Visualization: Add a table visualization to your report and place the "State or District" calculated column in the first column and the "Total Sales" measure in the second column. 4. Conditional Formatting: To hide the "State or District" column when no slicer selection is made, you can apply conditional formatting to the table. Click on the "State or District" column in the table visualization, go to the "Format" pane, and under "Data colors," set the font color to match the background color (e.g., white). This will effectively hide the column when no selection is made. 5. Sync Slicers: Ensure that both slicers for "State" and "District" are synced across all pages of the report. Now, when no selection is made in the "State" slicer, the table will show the default values from the "State or District" calculated column, which is the "State" column and "Total Sales." However, when you select a specific state from the "State" slicer, the "District" column will be shown in place of the "State" column in the table visualization, along with the corresponding total sales for that district. This approach allows for dynamic column switching based on slicer selections, providing a more interactive and user-friendly experience in your Power BI report.

[@vinodkumarhs4000]

Can we use calculate table dax function in power pivot

[@BIConsultingPro]

Have you tried? I do understand that you have many queries but I'll appreciate if you try something first, and then ask your queries. Please do share your research or work, and then if you cannot do it, we will help you for sure.

[@kunaljain2154]

Hi sir..i have one query on many to many relationship..please guide me.

[@BIConsultingPro]

Hi, we have already created a video on many to many relationship and it's solution. Have you watch it? If no, please watch it. If you still have a query, kindly write us an email at [e-mail] kzbin.info/www/bejne/q6O3qKubobBgjsU kzbin.info/www/bejne/qmKrkIWEqbZ_ms0

[@Vlad236-rv4vp]

21 minutes into the video, I could not understand a thing. Accent is very thick, the background music is very loud

[@BIConsultingPro]

Thank you for your feedback! You can skip it if you don’t like it

[@Vlad236-rv4vp]

@@BIConsultingPro well...of course I can and I did. The comment was just a feedback in the assumption that a content creator would be interested in knowing how his content is perceived with the good and the bad.

[@rajaacmee]

The background music is annoying

[@BIConsultingPro]

Apologies for the inconvenience. However, we no longer use any background music.

[@dragonflylifestyle-travelm3565]

I watched 34 mins of this video. I have learned nothing from this video. There was no clarity in anything that was explained. I could not watch anymore.

[@BIConsultingPro]

Hi, We appreciate you taking the time to share your feedback. We are always looking for ways to improve our content and help people in their learning journey. We understand that each learner's experience can be different. To help us better understand your concerns and make necessary improvements, could you please provide more specific feedback on which parts of the video were unclear or what aspects you felt were lacking? Your detailed insights will be invaluable in helping us enhance our future content. Thank you for your time and constructive feedback. We look forward to hearing from you

[@TOO-FAM]

Please note that a lot of time has been waste just to know which pbix file is for which section in the tutorial because you have not named the files in relation to the video you made

[@BIConsultingPro]

Thanks for your feedback and I can imagine your situation. However, I'll request you to create your own .pbix file. Just understand how it's working.

[@chandrakalaborse5484]

Thanks for this valuable video, but background music is annoying. please try to skip that music

[@BIConsultingPro]

Sorry for that! KZbin doesn't allow to edit videos. However, we don't use any music nowadays.

[@chu1452]

Oml why are you using background music, the first 15 minutes is perfect

[@BIConsultingPro]

Apologies! Thanks for the feedback though. Soon, we will launch our new course.