This course is a sequence to part1 and in this course we are learning more dax functions, more practical examples and more clarity you will have on fundamentals. Detailed discussion on HASONEVALUE Dax including IF statementsWhat is a VALUES Function and how it can change the pivot calculations by giving you more control. What are implicit and explicit measures and why we should create latter ones. How to write TOPN Dax, one of my favorites. How to Use TOPN in practical scenarios. What is a DAX Studio and how do we download it and use it in Pivots - Challenges and reasons behind using dax studio. Learn the use of IF dax in PowerPivot. From writing simple IF functions to writing IF inside IFs, we are learning everythingHow to use IF as a calculated column and as a measure. What is the difference between both approaches. What is a SWITCH Dax and how it is used as an alternate of IF Dax. Learn one of the best dax - SUMMARIZEHow to use summarize in your grand totals and sub-totals. Learn how to customize calculations for pivot fields and pivot grand totals. Learn how to avoid showing data for few fields and how to show data for other fields. Focus on error messages when they come during calculations. Learn what message says about DAX and correct the formulas accordingly. Time intelligence functions - How to find cumulative sums of sales year wise, or month wise or quarterly basis. How to calculate the closing balance - month wise or year wiseHow to find the start of the year How to find the end of the year, month or quarterCreate calendar table and why it is important before using time intelligence functions and how to edit or create a relationship with main tables. how to add or whatever calculation to be done based on two dates - DATEBETWEEN
