• Post category:StudyBullet-2
  • Reading time:6 mins read

This course helps is you to deal with the important DAX functions that are useful in day to day reporting development.

What you will learn

Key DAX functionalities on the core working of the function itself

The working of DAX formulas

Learn the core concepts of Evaluation Context and setting the initial context

In this course you will learn Important and Advanced topics of DAX functions and Concepts with practical examples.

Description

Course covers different functions that are used in day to day reporting development and is helpful to understand the core concepts of these DAX functions. The videos are precise to topic and no additional information is covered other than the topic itself.

** This is not recommended for you , if you are already good at DAX and understand the core DAX functionality , as this course is designed for who wanted to explore the KEY DAX functions and just getting to learn DAX.

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


Get Instant Notification of New Courses on our Telegram channel.


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

English

Language

Content

Understanding Key DAX functions in POWER BI

Introduction

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 D

Create Dynamic Visuals Based on Ranking in Power BI using DAX