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

Рет қаралды 23,982

Күн бұрын

Student Files: prag.works/dax-made-easy-stud...
DAX Cheat Sheet: prag.works/cheat-sheet/dax
Quick links from the webinar: prag.works/lwtn/DAX-Made-Easy...
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.
👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit prag.works/MITCHELL40 for 40% off On-Demand Learning!
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/odl-trial-yt
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: prag.works/yt-twitter
✔️Facebook: prag.works/yt-fb
✔️Instagram: prag.works/yt-insta
✔️LinkedIn: prag.works/yt-li
✔️Discord: prag.works/yt-discord
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#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

Пікірлер: 23

@PragmaticWorks 2 ай бұрын

Student Files: 📄prag.works/dax-made-easy-student-files Certificate of Completion: 📄pragmaticworks.com/lwtn-dax-made-easy-certificate? DAX Cheat Sheet: ✔prag.works/cheat-sheet/dax Quick links from the webinar: ✔prag.works/lwtn/DAX-Made-Easy-links

@LucaKouwenhoven 2 ай бұрын

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 ^^

@terrylee2094 2 ай бұрын

Thanks for that

@PragmaticWorks 2 ай бұрын

This is great! Thank you, Luca. Did you use a tool for this or just a really great note-taker? 😀

@LucaKouwenhoven 2 ай бұрын

@@PragmaticWorks No tools, just noticed mid-session this morning that there weren't any chapters so went back to the start, went through what I'd seen noting timestamps on my phone for decent chapter separation, thought of the titles in addition to the one in the session and then finished the rest while noting timestamps all the way to the end ^^ And then wrote the comment on my computer using my notes ^^ Happy to see that you already incorporated them in the session itself ^^ Also thanks for all the content recorded on YT, I've been able to learn a lot about Power BI, data modeling and analysis in a short amount of time for my internship !

@PragmaticWorks 2 ай бұрын

@@LucaKouwenhoven We are glad you are enjoying the content and appreciate the assist on the chapters. Thank you!

@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.

@melodym5993 2 ай бұрын

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

@mishymoo34 2 ай бұрын

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

@jawadahmadehssan6251 2 ай бұрын

Thank you Michel for this great content.

@datawizibility 2 ай бұрын

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

@azzurikayvo 2 ай бұрын

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

@furkansimsek33 2 ай бұрын

Great course, thank you for sharing :)

@AlaaMarriott Ай бұрын

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

@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.

@PragmaticWorks Ай бұрын

This document here, is very thorough: learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview

@angelabot7682 2 ай бұрын

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?

@PragmaticWorks 2 ай бұрын

You can find the files here: prag.works/dax-made-easy-student-files

@angelabot7682 2 ай бұрын

I got the right files through the link in the "Thank You" email I received from Pragmatic Works, Thanks!