Understanding Key DAX functions in POWER BI

Key Topics Covered in the Course :

· Understanding Context in Power BI

· Evaluation Context or Initial Context in Power BI

· Aggregations or Filter Context in Power BI

· Iterations or Row Context in Power BI

· Understanding Cumulative Sales Calculation

· Understanding Rolling Total Calculation

· Power BI Slicer Selections To Use With Different Measures

· Understanding ALL Function

· Using TOPN Function

· Understanding ALLSELECTED Function

· Understanding LASTNONBLANK Function

· Understanding TREATAS Function

· Difference between USERELATIONSHIP & TREATAS

· Calculating MEDIAN value

· Understanding CALCULATETABLE Function

· How And When To Use PARALLELPERIOD

· Different Ways You Can Use The TOPN Function

· Uses of Iterating Formulas In Power BI

· The Main Difference Between ALL And ALLSELECTED

· Advanced RANKX – Deep Understanding

· How To Use The GROUPBY Function In Power BI

· Dealing With Mulitple IF Statements In Power BI Using DAX

· Dynamically Change Size Of Visual Based On Ranking Selection in Power BI using DAX

· Create Dynamic Visuals Based on Ranking in Power BI using DAX