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


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.


© 2021 hugecourses.com. All rights reserved.
View Sitemap