[Power BI] Advanced DAX with CALCULATE: The Most POWERFUL Function in DAX

Описание: 🚨Start creating interactive and dynamic reports with Power BI now. Learn about the Power BI Experience Course: https://powerbiexperience.com/en/cour...

Take advantage of the promotional discount to take the Course and join the Power BI Experience Community.

---------------------------------------------------------------------------------------------------

Download materials: https://bit.ly/lessonspbi_

---------------------------------------------------------------------------------------------------

The focus of Power BI video today is DAX Language. I will explain in detail how the main function of Power BI calculation works, CALCULATE.

You will learn what the CALCULATE function is for, what its syntax is, how it interacts with other functions such as ALL, ALLSELECTED and VALUES.

Also, in this Power BI class you will learn:

What is filter context

How to make comparative calculations in Power BI

How to use variables in Power BI to optimize your calculations

How to calculate the percentage by subcategory in Power BI

If you are looking for a lesson that will teach you how to do your first calculations with Power BI and also teaches you very important concepts such as what is a filter context, you are in the right place. Just play the video and don’t forget to leave the like.


---------------------------------------------------------------------------------------------------
Content of this video:

00:00 – Introduction
02:29 – Filter Context
06:00 – Row Context
10:26 – Calculate function
15:59 – Calculate + ALL
20:40 – Calculate + ALLSELECTED
25:18 – Calculation percentage for subcategory
30:45 – Applying 2 filters in the calculation
37:36 - Calculate with Time Intelligence
45:15 – Cumulative Sums
57:17 – Cast doubt

---------------------------------------------------------------------------------------------------

Other Recommendations:

Guide to Data Modeling, DAX, Filter Context and CALCULATE function:    • [Power BI] Guide to Data Modeling, DAX, Fi...  

Time Intelligence with DAX and how to use Tabular Editor:
   • [EN] [Power BI Lesson #08] Time Intelligen...  

DAX Table Functions - CALCULATETABLE + INTERSECT + EXCEPT + VALUES:    • [EN] [Power BI Lesson #07] DAX Table Funct...  

---------------------------------------------------------------------------------------------------

👉 Subscribe to our channel:    / aprendapowerbi  
👉 Activate notifications (click on the bell 🔔)!
👉 Leave your like!

---------------------------------------------------------------------------------------------------

Follow all about Power BI on the other social networks:

👉 Telegram: https://t.me/PBIeXperience
👉 Instagram:   / leokarpa  
👉 LinkedIn:   / leokarpa  

#powerbi #leonardokarpinski #powerbiexperience