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

Описание: Student Files: https://prag.works/dax-made-easy-stud...
DAX Cheat Sheet: https://prag.works/cheat-sheet/dax
Quick links from the webinar: https://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 https://prag.works/MITCHELL40 for 40% off On-Demand Learning!
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:

✔️Twitter: https://prag.works/yt-twitter
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li
✔️Discord: https://prag.works/yt-discord

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#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