No More DAX? Power BI’s NEW Feature Explained (File Included)
ฝัง
- เผยแพร่เมื่อ 16 ต.ค. 2024
- With Visual Calculations, you might not need DAX anymore in Power BI.
👩🏫 Learn more about my Power BI course: bit.ly/3zHT4SM
⬇️ Download the example file here and follow along: bit.ly/viscalc...
Ever felt overwhelmed by the complexity of DAX formulas in Power BI? Or maybe you’re just getting started, and the thought of mastering DAX feels like a huge challenge. What if I told you there’s a simpler way to handle all those calculations?
Say hello to Power BI's brand-new Visual Calculations. Visual Calculations simplify writing DAX measures enabling you to directly reference fields in your visuals. That means less hassle and more time to focus on what really matters. Let me show you how you can use Visual Calculations to create powerful reports in no time.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetr...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetr...
#Excel #PowerBI #VisualCalculations
❓What’s the most challenging DAX formula you’ve worked with?
Learn more about my Power BI course: bit.ly/3zHT4SM
Pareto chart. I've tried the add-in for pareto, but it isn't easy to customize it the way I want. My DAX looks like this:
Cause Pareto % =
VAR __CurrentCause = SELECTEDVALUE(QM15[Cause group text]) RETURN
IF( NOT ISBLANK( __CurrentCause ),
VAR __AllselectedCauses = ALLSELECTED( QM15[Cause group text] )
VAR __CauseTable =
ADDCOLUMNS(
__AllselectedCauses,
"@Count", [QNs Count],
"@Rank", RANKX( __AllselectedCauses, [QNs Count] ) +
RANKX( __AllselectedCauses, QM15[Cause group text] )/1000000
)
VAR __CurrentCausePos = MAXX( FILTER( __CauseTable, QM15[Cause group text] = __CurrentCause ) , [@Rank] )
VAR __CumCauseCount = SUMX( FILTER( __CauseTable , [@Rank]
Super awesome thanks Mynda! This will save a lot of time if one is not a DAX pro.
Glad you like it, Chris!
You just make things so easy to understand. Thanks from South Africa.
Thanks for your kind words, Chris!
Hi Mynda.
Your TH-cam Channel is among the Best.
You put a lot of effort into presenting better Content with good Pedagogy.
I really admire your Videos on Power Bi.
Thank you and Good Luck.
Thanks for your kind words and support!
Congratulations, excelent explanation!!!!.
What is the complexity of this calculation?
Does retrieve all the data from origin or Does use the data from the visual?
It uses the data from the visual.
Useful video! Can I also add visual calculations in the report editor in the web browser?
Yes you can!
@@MyOnlineTrainingHub Thank you!
Hi there Mynda and thank you for this important tutorial! Is this option of 'New calculation' Limited to certain editions of power bi? I only see 'new measure' and 'quick measure'. I have a surprisingly simple calculation to register that I cannot easily do, which is to do with summing several fields. When I select the fields I wish to aggregate (each field itself is an aggregate), only the last one is retained.
Hi John, you need to enable this feature as it's still in preview. Go to the Options and settings > preview features to turn it on.
@@MyOnlineTrainingHub Found it thank you! It was called Visual calculation I think
Many thanks , useful as always , one question please, why I can't see new calculation function on my menu bar , my BI version is Aug 2024 , thanks again.
You need to enable it in the Preview features via the Options.
Thank you so much, Mynda! Like you, I suspect that when this feature comes out of preview, they'll have other options available in Visual Calculations.
Thanks for watching, Jesse!
Thank you so Mynda for this video. I would like to go through your entire PowerBI course however, it seems like bitly link is not working. I am getting failed to open page message whenever I click on this link. Can you pls check the link and update it?
That's odd, the bit.ly link works for me. Here's the page link, hopefully that works, but let me know if not: www.myonlinetraininghub.com/power-bi-course
@@MyOnlineTrainingHub The provided link I can access. Thanks a ton.
Really thanks a lot ! Mynda .I was struggling literally with this DAX functions.
Glad you can make use of this new feature!
I have a bad news you guys who don't write DAX formulas. You need always DAX. Practice makes you better.
Practice does indeed make you better and more fun 😜
I find writing DAX pretty tedious (I basically only ever use it if some calculation absolutely requires dynamic context), so this is definitely going to be of use. Hope it's in GA soon. Cheers.
Great to hear you can make use of this new feature!
FANTASTIC!!!! Great work (as always)!!
Thanks for watching!
Does this feature start with the August 2024 update or Sept 2024? Your video description doesn't say.
I see it is in as a Preview Feature starting in the Feb 2024 version and I didn't turn that on.
It's still in preview.
Thanks for this useful tutorial!
Glad it was helpful!
Thanks a ton Ma'am for this informative video.
My pleasure 😊
I cannot see any visual calculations tab in my power BI desktop. In which version is it available?
You have to enable it as shown at the end of the video. It’s a preview feature.
Do you have courses in Udemy. If yes, with what name?
No. I have courses on my site here: www.myonlinetraininghub.com/courses
Many Thanks
You are welcome 😊
My watch later playlist just ended Ninja Mi Ninja and onto discussing DAX. We truly have our pick of content to indulge. 😅
😁
Thanks for sharing, I hope you like our work. There is much more to come! I will have a surprise for you next month 😊
Can't wait, Jay! Congratulations on what you've achieved so far 👏
Thanks
Welcome 😊
i spent more than an hour to figure out why my home tab wasn't showing Visual Calculation, it would have been nice, if you could add that to your video how to get it to your ribbon tab
I show you how to get them towards the end of the video. File tab > Options & Settings > Options > Preview Features > Visual Calculations
Did they change these so users can export to excel with them? When it was in preview this was not the case and so we continued to just use regular DAX measures.
They're still in preview, but I didn't test that, so not sure.
Simple superb explained
Thank you 🙂
Excelente, muchas gracias!
Gracias!
super class for power bi
Thanks so much!
It's an addition, it doesn't replace regular DAX at all.
I have the latest version of Power BI but it does not have the "New Calculation" option. Any idea?
You have to enable it in the Options.
Can we use DAX to hide for example the quarter totals of the 3 month moving average which doesn't really make much sense?
You can write your own DAX measure to do this, yes.
Hi .. kindly include in your list how to do integrated financial reporting (income statement, cash flow and balance sheet using power query and power bi...thanks for sharing with us .
The answer to that is, not easily. 😜 as a result, I don't have any plans to do videos on these topics as they're very complicated.
this has been there in mstr since 15 years ago .... so what if they charged premium for innovation or features which are not available elsewhere!
Awesome!
Glad you like it!
When I fecting data from excel sheet , all values coming with summation symbol
That sounds odd. Although, you should be able to clear it up with Power Query before loading to the data model.
Amazing
Glad you like it!
Why don't they provide a T-SQL wrapper for DAX.
Good question.
Dax was/is a nightmare. Far too complicated. Glad it's going.
😂 It's not going anywhere. This is just an option in certain situations.
preach
is it only with Microsoft 365???
Power BI is not part of 365, so it's for anyone with Power BI. You need to enable the feature as shown in the video.
this is awesomeeee
Glad you like it!
Glad you like it!
I think I saw this feature on tableau ages ago...
Probably 😉
What is DAX?
DAX is the formula language used by Power Pivot aka the Data Model which is found in Excel and Power BI. It stands for Data Expression Analysis.
super
Thank you 😊
why don't they just make python the default language for Power BI -- it would make things so much more simple
For python users, sure, but not for most people 😁
Visual calculations is still DAX.
Yeeeeeees
😁 have fun with it!
💚💚💚
Glad you like this new feature 😊
Wait, did you explicitly said, that data manipulation, data engineering and everything what's happening under the hood does not matter?
Not exactly 😁
Well it is important for sure , but you can test the templates and see how they behave .
Everything os moving to a functional environment
Came here to learn how I could avoid using DAX. Because I hate DAX. It's unnecessarily complicated. Why on earth isn't it closer to SQL syntax for the standard stuff? It's so annoying. Sad to see that this video doesn't provide a real alternative. 😢
Dax ain't goin nowhere
Dax is too complicated
Not for long 😜
DAX is a nightmare to learn
It can be challenging, yes!
clickbait
“Bye-bye DAX” ? Err no, I don’t think so. This is a gimmick for lazy users who can’t be bothered to learn. But I don’t mind that as those people will never be a threat to me 😂