Welcome to my intermediate level for Power BI users who want to delve deeper into the DAX functional language. After taking my Power BI Data Analysis Course (for beginners) you now will be ready to take your skills to the next level and really get a grasp on the DAX language that is used in Power BI formulas.
In this course we will implement over 30 DAX functions from across nine different categories:
Conditional & Logical Functions
IS Functions
Date & Time Functions
Conversion Functions
Math & Stats Functions
Text Functions
Iterator Functions
Time Intelligence Functions
Table & Filter Functions
Infamous CALCUALTE Function
I will teach you how to problem solve your formulas and how to build them in pieces, so they are easier to understand and use that knowledge to have your measures call other measures. Not to mention learn to build a measures table to hold all the measure you will create for your report to keep them organized and all in one place.
You will also learn the need to have a rolling calendar and the benefits it provides for those people who have a multitude of tables with date fields and how the table will auto adjust its dates as new data is added.
All that combined with installing appealing new visuals from the marketplace and using stunning slicers to make your reports more interactive for your user. By the end of this course, you will have the confidence to build out your formulas to get the results you need and the visually appealing new visuals on your reports that show the results of your data analysis for the company!