Visual Calculations in Power BI - DAX Made Easy! [Full Course]

In this session led by Mitchell, attendees will gain insights into leveraging visual calculations to streamline DAX calculations in Power BI.

Mitchell will explore this new capability, providing participants with a clear understanding of its functionality and potential applications. Emphasis will be placed on replacing complex DAX calculations with simplified visual calculations.

You and Mitchell will also explore:
- Optional parameters and their implications in enhancing analysis and reporting tasks
- Considerations and limitations associated with visual calculations compared to conventional DAX writing methods

By the end of the session, attendees will have acquired practical knowledge to simplify their DAX calculations effectively while being mindful of the existing constraints.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#PragmaticWorks #powerbi #dax #data

0:00 Intro
3:22 Requirements
6:00 Slides Presentation
8:00 Demo Start
12:05 First Calculation, Running Sum
21:43 Formatting
23:13 Calculation limited to Visual
25:53 YTD, QTD, etc...
35:40 Moving Sum
42:41 Moving Average
55:07 Previous and Next Functions
1:00:21 Conditional statements in visual calculations
1:04:49 First and Last Functions
1:11:27 Collapse and Expand Functions
1:21:47 Documentation and Limitations

[PragmaticWorks]

Student Files:
Certificate of Completion:

DAX Cheat Sheet:
Quick links from the webinar:

[PandalPan]

Love it! The course is perfect for me! It's fast-paced and provides detailed explanations that enrich my knowledge. Thank you for sharing this.

[LucaKouwenhoven]

Chapters of the session ^^

1:10 : Start !
3:22 : Requirements
4:12 : Some Informations
6:00 : Slides Presentation
8:00 : Demo Start
12:05 : First Calculation, Running Sum
20:27 : 1st Question Time
21:43 : Formatting
23:13 : Calculation limited to Visual
25:53 : YTD, QTD, etc...
33:17 : 2nd Question Time
35:40 : Moving Sum
42:41 : Moving Average
51:19 : 3rd Question Time
55:07 : Previous and Next Functions
1:00:21 : Conditional statements in visual calculations
1:04:49 : First and Last Functions
1:11:27 : Collapse and Expand Functions
1:21:47 : Documentation and Limitations
1:23:14 : Final Question Time
1:27:16 : Giveaway and Outro

Hope you enjoy the session and this helps you navigate through it ^^

[melodym]

Excellent as usual. Shared on LinkedIn, in case any colleagues or clients missed it. Professor Mitch is awesome!!!

[azzurikayvo]

Great Tutorial Mitchell. You go out of your way to drive in a point.

[mishymoo]

Loved this session, the presentation style was very engaging. Thanks.

[datawizibility]

Thank you for such a enriching and enlightening video. God bless

[jawadahmadehssan]

Thank you Michel for this great content.

[furkansimsek]

Great course, thank you for sharing :)

[jingxu]

Great course!! Can you share the T SQL shortcut for find-and-replace too? Thank you!!

[vamsikrishna]

Sir, I did not understand the Running Total Sales (m) at 20:00. If you say 'Date'[Date] <= MAX('Date'[Date], then [Total Sales] will be calculated for all the dates except that one maximum date. How would that change the result? Can you explain that?

[AlaaMarriott]

Smart tip using Format function, but if we sorted it will sorted as text not numeric, do you have a recommendation ?

[abrilgonzalez]

Thanks for the video!
¿Migh It be the case that the button "New Calculation" in the section "Calculation" doesn't exist?

¿Or maybe I have a new or old version of power bi, and that's why It might be the case that I cannot see the button?

thanks you!

[AlaaMarriott]

I have a column sales[agent] and a measure [Total sales], I tried "Running Sum" but it is sorted by sales[agent] column and can't be sorted by [total sales] measure, any option!!

[clintazotea]

Is there a library of Visual Calculations and the arguments they take? Example [14:33] how do you know the [Axis] argument takes ROWS as one of its options. Unless I saw this tutorial I'd have to do a web search on it.

[angelabot]

I've downloaded the files through the link above (Student files) but the content of the files is about "Copilot for Microsoft 365 Workshop" not "Visual Calculations in Power BI - DAX ". Please, how can I get the right files?

[lewismurigi]

Hey Can see the student file, Please assist