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

  Рет қаралды 93,074

Pragmatic Works

Pragmatic Works

Күн бұрын

Пікірлер: 37
@PragmaticWorks
@PragmaticWorks 8 ай бұрын
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
@LucaKouwenhoven 8 ай бұрын
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
@terrylee2094 8 ай бұрын
Thanks for that
@PragmaticWorks
@PragmaticWorks 8 ай бұрын
This is great! Thank you, Luca. Did you use a tool for this or just a really great note-taker? 😀
@LucaKouwenhoven
@LucaKouwenhoven 8 ай бұрын
@@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
@PragmaticWorks 8 ай бұрын
@@LucaKouwenhoven We are glad you are enjoying the content and appreciate the assist on the chapters. Thank you!
@PandalPan
@PandalPan 7 ай бұрын
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.
@azzurikayvo
@azzurikayvo 8 ай бұрын
Great Tutorial Mitchell. You go out of your way to drive in a point.
@jawadahmadehssan6251
@jawadahmadehssan6251 8 ай бұрын
Thank you Michel for this great content.
@melodym5993
@melodym5993 8 ай бұрын
Excellent as usual. Shared on LinkedIn, in case any colleagues or clients missed it. Professor Mitch is awesome!!!
@mishymoo34
@mishymoo34 8 ай бұрын
Loved this session, the presentation style was very engaging. Thanks.
@clintazotea
@clintazotea 7 ай бұрын
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
@PragmaticWorks 7 ай бұрын
This document here, is very thorough: learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview
@jingxu8448
@jingxu8448 4 ай бұрын
Great course!! Can you share the T SQL shortcut for find-and-replace too? Thank you!!
@datawizibility
@datawizibility 8 ай бұрын
Thank you for such a enriching and enlightening video. God bless
@vamsikrishna4562
@vamsikrishna4562 3 ай бұрын
Sir, I did not understand the Running Total Sales (m) at 20:00. If you say 'Date'[Date]
@PragmaticWorks
@PragmaticWorks 3 ай бұрын
The Calculated measure will return the total sales for ALL days in the date table before the MAX date in the filter context. The visual calculation is different because it's based off the data in the visual itself, and in this scenario the visual calculation is filtered down to the year 2007. Hope that helps! -Mitchell Pearson
@furkansimsek33
@furkansimsek33 8 ай бұрын
Great course, thank you for sharing :)
@Dubblejayy
@Dubblejayy 2 ай бұрын
Hello. I have the September 2024 version of Power BI and do not have the option to enable the visuals.
@AlaaMarriott
@AlaaMarriott 7 ай бұрын
Smart tip using Format function, but if we sorted it will sorted as text not numeric, do you have a recommendation ?
@AlaaMarriott
@AlaaMarriott 7 ай бұрын
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!!
@abrilgonzalez7892
@abrilgonzalez7892 4 ай бұрын
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!
@MitchellPearson
@MitchellPearson 4 ай бұрын
Hey! You may have jumped ahead just a bit, I talk about how to enable this feature around 3 minutes into the video, you do need to have atleast February 2024 or later! 😀
@abrilgonzalez7892
@abrilgonzalez7892 4 ай бұрын
@@MitchellPearson Oh my! Silly me. Thank you a lot!
@angelabot7682
@angelabot7682 8 ай бұрын
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
@PragmaticWorks 8 ай бұрын
You can find the files here: prag.works/dax-made-easy-student-files
@angelabot7682
@angelabot7682 8 ай бұрын
I got the right files through the link in the "Thank You" email I received from Pragmatic Works, Thanks!
@xyclos
@xyclos 3 ай бұрын
Fantastic as always. Thanks a lot
@cediesalazar2391
@cediesalazar2391 2 ай бұрын
Appreciate you men!
@MathifyAnalytics_24
@MathifyAnalytics_24 3 ай бұрын
This is great! Good tutorial!
@lewismurigi3623
@lewismurigi3623 8 ай бұрын
Hey Can see the student file, Please assist
@PragmaticWorks
@PragmaticWorks 8 ай бұрын
You can find the Files Here: prag.works/dax-made-easy-student-files
@jeroendekk1
@jeroendekk1 2 ай бұрын
Great video. I just don't get how this is easier then regular DAX. Its both equally hard / easy in my opinion.
@ParkerWhite-d7z
@ParkerWhite-d7z Ай бұрын
good video
@rolanceolgaiye1579
@rolanceolgaiye1579 Ай бұрын
cool ever
@RichardMarshall-e5t
@RichardMarshall-e5t Ай бұрын
guy has know clue what's going on smh
DAX Filter Context Basics [Full Course]
1:26:25
Pragmatic Works
Рет қаралды 71 М.
Mom Hack for Cooking Solo with a Little One! 🍳👶
00:15
5-Minute Crafts HOUSE
Рет қаралды 23 МЛН
Une nouvelle voiture pour Noël 🥹
00:28
Nicocapone
Рет қаралды 9 МЛН
Microsoft Fabric and Power BI - Developer of the Future⚡ [Full Course]
1:31:50
Beginner Power BI DAX Functions Tutorial [Full Course]
2:54:14
Pragmatic Works
Рет қаралды 1,6 МЛН
DAX REVOLUTION!? Visual Calculations in Power BI
33:15
How to Power BI
Рет қаралды 89 М.
Hands-On Excel Tutorial 📊 Beginner to Pro Course (2024)
1:30:55
Pragmatic Works
Рет қаралды 79 М.
Understanding Row Context in DAX using Power BI
19:47
Pragmatic Works
Рет қаралды 46 М.
Unboxing DAX Query View in Power BI - Unplugged #54
48:04
Power BI Dataflows Tutorial and Best Practices [Full Course] 📊
3:09:11
Pragmatic Works
Рет қаралды 443 М.
Learn 80% of DAX in an Hour (with FREE sample file)
1:02:21
Chandoo
Рет қаралды 78 М.
Power BI: Calculation Groups
27:32
Centida BI & Analytics
Рет қаралды 1,6 М.
Mom Hack for Cooking Solo with a Little One! 🍳👶
00:15
5-Minute Crafts HOUSE
Рет қаралды 23 МЛН