Visual Calculations - Making [DAX] Easier (with Jeroen ter Heerdt)

This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting new feature!
Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. Get ready to get your mind blown! See the future, today.
GUEST BIO (Jeroen ter Heerdt) 👤
Jeroen ter Heerdt is a Product Manager with Microsoft. He works on Power BI and is passionate about "all things data"; whether it is about databases, data warehousing, BI, big data, data visualizations, self-service BI, advanced analytics, real-time BI or anything even remotely related to data or insight. He strives to apply these concepts in his life as much as possible. Jeroen combines enthusiasm, vision, and hands-on experience into his talks.
RELATED CONTENT 🔗
Blog -- www.dutchdatadude.com
LinkedIn -- / jeroenterheerdt
Understanding Visual Calculations -- learn.microsoft.com/en-us/pow...
VIDEO CHAPTERS 📺
0:00 - Video Start
5:00 - Start of Live stream
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
CHECK OUT OUR MERCH STORE 👕
-- havens-consulting.creator-spr...
HAVENS CONSULTING PAGES 📄
Home Page -- www.havensconsulting.net
Blog -- www.havensconsulting.net/blog-...
Blog Files -- www.havensconsulting.net/blog-...
Files & Templates -- www.havensconsulting.net/files...
Consulting Services -- www.havensconsulting.net/consu...
Online Course -- www.havensconsulting.net/onli...
Contact & Support -- www.havensconsulting.net/conta...
EMAIL US AT 📧
[e-mail]
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #visualcalcs #visualcalculations #reporting

[@lucasshipsides1510]

based on some of the "teasing" i'd heard for this i'd decided to temper my expectations, but i am super impressed by how this is going to work!

[@HavensConsulting]

It's really going to change how people write DAX honestly! I can't wait for it to hit general availability

[@dutchdatadude]

not sure what you're referring to? We're excited to bring this to your Desktop in March 2024!

[@lucasshipsides1510]

@@dutchdatadude those who had spoken about the upcoming feature in other livestreams didn't seem particularly excited and called out that it was basic

[@dutchdatadude]

@@lucasshipsides1510 that's not the read I am getting, but I have not seen all livestreams of course. It's not basic, but I am biased. If you have links, I'd love to learn!

[@dkfromthebay]

Surprised msft didn't just acquire Inforiver to get this plus the UI/UX ready to ship

[@JustRandomExplorer]

Hmm, super interesting! Thanks for the video. One thing that popped into my mind when you guys said that Visual Calcs are like shortcuts to Window Calcs. Could there be some "translate this visual calculation to window calculation" -button or "show as window calc" -translator. This way we could easily transform Visual Calculation to Window Calculation and use the Window Calculation measure in multiple visuals. Thanks for the video!

[@JustRandomExplorer]

Oops, you actually answer this at 43:40 😀

[@In_a_state]

This will change reporting quite a bit, the speed benefits in some cases will be amazing. It's fantastic to not have to iterate over data model tables/columns but an aggregation. However, it would be useful to have visual calculations storable and reusable, just like normal measures. Whenever you would reuse a visual calculation in a different visual the dependencies (measures/other visual calculations) would be added to the visual as well so the calculation can function.

[@dutchdatadude]

thanks for the feedback! Our current thinking is indeed that you'd be able to copy/paste visual calcs between visuals. That action would bring over anything that the visual calc depends on onto the new visual. Does that meet your needs? Right now there is no plan for visual calcs to be stored in the model as such, although we have considering providing a way to convert a visual calc to a measure.

[@In_a_state]

@@dutchdatadude I think displaying the list of visual calcs somewhere would be needed. Otherwise how would you find such a calculation in the report to reuse it? Shouldn't have to rely on memory and checking visuals too much, in my opinion. Could I also bring something else to your attention? It's quite cumbersome to navigate formulas when there are chained measures without using external tools. You have to search the dependency to view it, losing time in the process. It would be good if we could double-click a measure in the DAX editor window to open that measure.

[@dutchdatadude]

@@In_a_stateagreed on the first thing, this is something we're thinking about. We are not working on anything related to #2 just now.

[@dkfromthebay]

If the visual measure refers to placeholders like Value1 and Value2 (based on the measures in the values well and their order) then they could be reusable

[@dkfromthebay]

⁠you can do this in the new query view. Right click on a measure reference and select Define and it puts the dax for that measure in the query editor

[@Gandalf1969Guy]

Visual Calculations - OMG I usually do this manually for my more complex data visualisations, if not for my own design/debugging but this will also help with user testing and data validation processes. When will you flip the switch on this one for us to see and use?

[@HavensConsulting]

He mentioned it should be around March/April!

[@huaquanzhu2758]

where can we get this PPT or PDF file？thanks

[@HavensConsulting]

Let me ask Jay and get back to you :)

[@huaquanzhu2758]

thank you very much@@HavensConsulting

[@user-lk9ic7dr9l]

in the name of all that is good and holy, please remove the background music from your livestreams. it is an extraneous embellishment, and distracts from your otherwise solid core content.

[@HavensConsulting]

I appreciate the honest opinion of it being extraneous to you. I get people on both sides people who enjoy it, and others who want it removed. Personally as the host I prefer to keep it in as it helps fill in dead space when there is potential tech issues, or waiting on stuff to load. Which at 115+ streams hosted, has happened. Following similar practices that Adam and Patrick do on Guy in a Cube with each stream they do :) Example here: kzbin.info/www/bejne/oHfVXqJvapiXo80