# PowerPivot with Dax Part 2 – 2

## What you’ll 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

• You will learn IF statements – Basic to advance

• How to use SWITCH Dax – Which one is better – IF or SWITCH

• How to use IF as a calculated column and as a measure and which option is best or should you use when.

• TOPN Dax for calculating the TOP entries from different date ranges

• How to customize the pivot fields calculations with grand totals and sub totals

• In section2 learn about Time Intelligence DAX functions from scratch.

• Practical examples in day to day life also has been explained .

• How to download it and how to launch it in power pivot

• Do we really need DAX Studio and for what purposes it can be used.

• Another amazing DAX – Summarize with practical examples.

• What is implicit and Explict measures

• Which one better and why – Implicit or Explicit

## Requirements

• You should have seen this course Part1 as this is in continuation to the previous one.

• You should be familiar with PowerPivot DAX language as this course is not intended for those who lacks knowledge of power pivot.

• You should have excel 2013 or afterwards versions which supports powerpivot.

• 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

## Who this course is for:

• Students or Working professionals or Business Analysts who work on excel pivots and make summary reports and dashboards all the time can take this course as this will teach them how to fully use the pivot by creating any type of a formula for any type of analysis.
• How to use IF DAX as a Measure – Just fundamentals and nothing more.

07:49

• Switch DAX -Another alternative of IF Function – It is super fast

16:19

• Introducing DAX Studio & TOPN Dax -Part1

30:03

• How to use TOPN Dax – Part2

04:55

• How to use TOPN Dax – Part3

02:46

• HASONEVALUE DAX – It is outstanding Part1

13:12

• HASONEVALUE DAX – It is outstanding Part2

14:29

• SUMMARIZE – Long awaited DAX – Its simply awesome

39:07

• SUMMARIZE DAX – Continued..

45:30

• IMPLICIT and EXPLICIT Measures – Must know thing

17:41

Instructor – Advance Excel, Excel Vba ,Access, Access Vba

I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.