PowerPivot with Dax Part 2/2

PowerPivot with Dax Part 2/2

• 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 statements

• What 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 everything

• How 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 - SUMMARIZE

• How 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 wise

• How to find the start of the year

• How to find the end of the year, month or quarter

• Create 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

Take your Pivot Dax to a new levels.

Url: View Details

What you will learn

• This is PowerPivot with DAX Part2 and it is in continuation to part1. This course will make you superb in PowerPivot DAX Lanaguage.
• This course will give you insight on the importance of DAX in PowerPivot and how it has no comparison with old traditional pivots.
• You will learn HASONEVALUE Dax

Rating: 4.75

Level: All Levels

Duration: 6 hours

Instructor: ajay parmar