NEW Power BI Visual Calculations | Feb 2024 (Full Tutorial with PBIX Dashboard Included!)

In this hands-on demo, Maven Analytics Founder Chris Dutton introduces Power BI’s brand new visual calculations (released to preview in February 2024).
We’ll break down exactly how visual calculations can be applied in Power BI Desktop, explore common use cases like running totals, percent of parent and positional reference calculations, then review some of the major pros and cons compared to traditional DAX measures and calculated columns.
As a bonus, you can follow along by downloading the same dashboard used in the demo, or build it yourself from scratch when you enroll in our best-selling Power BI Desktop course.
🔗 Links to resources:
👉AdventureWorks Power BI file (pbix):
maven-datasets.s3.amazonaws.c...
👉Maven Analytics Power BI Desktop course: mavenanalytics.io/course/micr...
👉Power BI February 2024 Feature Summary: powerbi.microsoft.com/en-us/b...
👉Microsoft Visual Calc Documentation: learn.microsoft.com/en-us/pow...
⏱️ Timestamps ⏱️
00:00 - Intro
00:43 - What are visual calculations?
02:05 - Key benefits of visual calcs
03:12 - Calculation templates
04:50 - DEMO: Running sum
05:52 - DEMO: Moving average
06:58 - DEMO: Positional references (Previous, Next, First, Last)
09:01 - Showing/hiding calculated fields
11:08 - Formatting visual calculations
12:21 - DEMO: Percent of parent
14:23 - DEMO: Percent of grand total
15:30 - DEMO: Average of children
17:23 - Modifying bar charts
19:19 - Pros & cons of visual calcs
At Maven Analytics we empower everyday people with life-changing data skills. Head to mavenanalytics.io and master in-demand tools like Excel, SQL, Power BI, Tableau, Python and more. Start learning for FREE!
Looking for more opportunities to sharpen your skills? Explore sample datasets hand-picked by Maven instructors, and practice solving real business problems with expert-led guided projects: mavenanalytics.io/guided-proj...
Happy learning!

[@MavenAnalytics]

🔗 AdventureWorks Power BI file (pbix): maven-datasets.s3.amazonaws.com/AdventureWorks+Power+BI+Report/AdventureWorks+Report_FINAL.pbix.zip

[@mrjpwalkinson7495]

The file is corrupted or cannot be found, can you please re-upload it. cheers !

[@mariorauldelapena2052]

Thanks!!!!

[@siqizhang7689]

Should your be able to transform text format of Profit to number by “+0” or “*1”?

[@dwijenbaruah8257]

Excellent Explanation!!
Please see, file attached is not the right one.

[@jupitershorizons]

I watched it just to see if Chris went the whole video without saying "game changer". LOL! j/k Nice presentation of this feature. Thank you!

[@Chris-at-Maven]

Guilty as charged 😆

[@AncientWonders-g5q]

Dax is very difficult/complicated