No More DAX? Power BI’s NEW Feature Explained (File Included)

Подписаться 648 тыс.

Просмотров 106 тыс.

50% 1

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

Опубликовано:

7 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 90

@MyOnlineTrainingHub Месяц назад

❓What’s the most challenging DAX formula you’ve worked with? Learn more about my Power BI course: bit.ly/3zHT4SM

@throndjohnson Месяц назад

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]

@chrism9037 Месяц назад

Super awesome thanks Mynda! This will save a lot of time if one is not a DAX pro.

@MyOnlineTrainingHub Месяц назад

Glad you like it, Chris!

@ExcelWithChris Месяц назад

You just make things so easy to understand. Thanks from South Africa.

@MyOnlineTrainingHub Месяц назад

Thanks for your kind words, Chris!

@hitesh202 7 дней назад

Really thanks a lot ! Mynda .I was struggling literally with this DAX functions.

@MyOnlineTrainingHub 7 дней назад

Glad you can make use of this new feature!

@tmb8807 Месяц назад

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.

@MyOnlineTrainingHub Месяц назад

Great to hear you can make use of this new feature!

@jessemacdonough2458 Месяц назад

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.

@MyOnlineTrainingHub Месяц назад

Thanks for watching, Jesse!

@BossLevelPro 8 дней назад

My watch later playlist just ended Ninja Mi Ninja and onto discussing DAX. We truly have our pick of content to indulge. 😅

@MyOnlineTrainingHub 7 дней назад

😁

@user-xq4gz3oq7d 29 дней назад

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?

@MyOnlineTrainingHub 27 дней назад

It uses the data from the visual.

@TheCnshn Месяц назад

I have a bad news you guys who don't write DAX formulas. You need always DAX. Practice makes you better.

@MyOnlineTrainingHub Месяц назад

Practice does indeed make you better and more fun 😜

@tibibara 24 дня назад

Thanks for this useful tutorial!

@MyOnlineTrainingHub 23 дня назад

Glad it was helpful!

@charithaperera4768 Месяц назад

Many Thanks

@MyOnlineTrainingHub Месяц назад

You are welcome 😊

@r.vinodjames3083 27 дней назад

super class for power bi

@MyOnlineTrainingHub 27 дней назад

Thanks so much!

@regme4life191 Месяц назад

Thanks a ton Ma'am for this informative video.

@MyOnlineTrainingHub Месяц назад

My pleasure 😊

@mohammedaltaf4877 Месяц назад

Thanks

@MyOnlineTrainingHub Месяц назад

Welcome 😊

@dutchdatadude Месяц назад

Thanks for sharing, I hope you like our work. There is much more to come! I will have a surprise for you next month 😊

@MyOnlineTrainingHub Месяц назад

Can't wait, Jay! Congratulations on what you've achieved so far 👏

@mahadevkanchu8951 Месяц назад

Simple superb explained

@MyOnlineTrainingHub Месяц назад

Thank you 🙂

@fernandozarate1725 Месяц назад

Excelente, muchas gracias!

@MyOnlineTrainingHub Месяц назад

Gracias!

@syrophenikan Месяц назад

FANTASTIC!!!! Great work (as always)!!

@MyOnlineTrainingHub Месяц назад

Thanks for watching!

@dutchinfluencer Месяц назад

It's an addition, it doesn't replace regular DAX at all.

@anindadatta164 Месяц назад

I cannot see any visual calculations tab in my power BI desktop. In which version is it available?

@MyOnlineTrainingHub Месяц назад

You have to enable it as shown at the end of the video. It’s a preview feature.

@elvyrorie1432 21 день назад

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.

@MyOnlineTrainingHub 21 день назад

They're still in preview, but I didn't test that, so not sure.

@mosesopondo5131 Месяц назад

Awesome!

@MyOnlineTrainingHub Месяц назад

Glad you like it!

@deenkiroshni-pf4ur 28 дней назад

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

@MyOnlineTrainingHub 27 дней назад

I show you how to get them towards the end of the video. File tab > Options & Settings > Options > Preview Features > Visual Calculations

@ubaidimran7102 Месяц назад

Why don't they provide a T-SQL wrapper for DAX.

@MyOnlineTrainingHub Месяц назад

Good question.

@samuelmundia320 Месяц назад

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 .

@MyOnlineTrainingHub Месяц назад

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.

@X4Xubi Месяц назад

I have the latest version of Power BI but it does not have the "New Calculation" option. Any idea?

@MyOnlineTrainingHub Месяц назад

You have to enable it in the Options.

@xeeshanahmad8757 Месяц назад

Amazing

@MyOnlineTrainingHub Месяц назад

Glad you like it!

@vikrammohite8673 25 дней назад

When I fecting data from excel sheet , all values coming with summation symbol

@MyOnlineTrainingHub 25 дней назад

That sounds odd. Although, you should be able to clear it up with Power Query before loading to the data model.

@podamaire Месяц назад

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!

@neilgore Месяц назад

super

@MyOnlineTrainingHub Месяц назад

Thank you 😊

@hamishmaxa6509 Месяц назад

Can we use DAX to hide for example the quarter totals of the 3 month moving average which doesn't really make much sense?

@MyOnlineTrainingHub Месяц назад

You can write your own DAX measure to do this, yes.

@edge5817 Месяц назад

this is awesomeeee

@MyOnlineTrainingHub Месяц назад

Glad you like it!

@MyOnlineTrainingHub Месяц назад

Glad you like it!

@domenicoieracitano2138 Месяц назад

I think I saw this feature on tableau ages ago...

@MyOnlineTrainingHub Месяц назад

Probably 😉

@alkagupta2401 Месяц назад

Do you have courses in Udemy. If yes, with what name?

@MyOnlineTrainingHub Месяц назад

No. I have courses on my site here: www.myonlinetraininghub.com/courses

@charliearmour1628 Месяц назад

Dax was/is a nightmare. Far too complicated. Glad it's going.

@b0159673 Месяц назад

😂 It's not going anywhere. This is just an option in certain situations.

@juanpablorvvv 4 дня назад

Visual calculations is still DAX.

@sumitavamaji3294 Месяц назад

is it only with Microsoft 365???

@MyOnlineTrainingHub Месяц назад

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.

@robertbox5399 Месяц назад

What is DAX?

@MyOnlineTrainingHub Месяц назад

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.

@firstname4337 Месяц назад

why don't they just make python the default language for Power BI -- it would make things so much more simple

@MyOnlineTrainingHub Месяц назад

For python users, sure, but not for most people 😁

@ksspqf6016 Месяц назад

Yeeeeeees

@MyOnlineTrainingHub Месяц назад

😁 have fun with it!

@tihomirhristov77 Месяц назад

💚💚💚

@MyOnlineTrainingHub Месяц назад

Glad you like this new feature 😊

@chriskeo392 Месяц назад

Dax ain't goin nowhere

@PixelMotionHD Месяц назад

Wait, did you explicitly said, that data manipulation, data engineering and everything what's happening under the hood does not matter?

@MyOnlineTrainingHub Месяц назад

Not exactly 😁

@oscararmandocisnerosruvalc8503 Месяц назад

Well it is important for sure , but you can test the templates and see how they behave . Everything os moving to a functional environment

@ashbeez1090 Месяц назад

DAX is a nightmare to learn

@MyOnlineTrainingHub Месяц назад

It can be challenging, yes!

@mathijs9365 Месяц назад

Dax is too complicated

@MyOnlineTrainingHub Месяц назад

Not for long 😜

@imconfused1237 Месяц назад

“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 😂