DAX Fridays
Vložit
- čas přidán 3. 07. 2024
- Preparing for another DAX video, I came across an example that perfectly exemplifies why DAX can be so hard to understand.
Chapters:
00:00 Intro
00:20 Examples of different contexts
03:40 Do I have any filters applied to my visual?
04:50 How to get better at DAX
Done!
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
thank God there is a community out there to help one another for DAX. thanks for the video.
Agreed!!
Thank you Ruth, a perfect example to demonstrate how DAX is contextual.
I absolutely love your channel. Very helpful content + the way you explain is very simple yet profound. Thank you!!!
Nice explanation Ruth :) Looking forward to learn more from you this year as well !
Thanks Abhishek!
The good and old filter context :P. On the card, when you selected all date on the slicer you ended up with no filter context whatsoever, whereas, in the table visual there is a filter context applied due to the table axis (the left most column, date).
Great to have you back. Happy New year
Happy New Year!
Thanks ruth for sharing. I really love your videos!
I come from a Qlikview background, which was so much easier than dax. I loved it. It was also very powerfull.
Our company switched to powerBI, now I have to take all these filter in to account. and create a table to do certain calculations.
Very frustrating, knowing that something so simple, can sometimes can be so difficult. Next video should be how do you cope with the frustration when working with dax :P
Thank you for sharing your knowlegde with us. God bless you!
😂😂😂
Thanks for the feedback and great idea on a video, I will take you up on that :)
Hi Ruth, thank you for posting this! I believe the reason the PREVIOUSDAY returns nothing when there are no filters is because it uses the date table to get the previous day. Since there is no entry date before the first date in the table it returns no value. This is instructive, as I would have thought PREVIOUSDAY is syntax sugar for DATEADD(DateTime[DateKey],-1,day). Clearly it is not!
Thanks for your videos, row context, filter context, context transitions... I forgot how the Italians described it, but it goes something like this "dax is not hard, just difficult to understand" or something like that 😂
I will have to respectfully disagree:
DAX is hard, unless you are italian that is... 🤣🤣
Thanks for this video. Yes, DAX can be tricky many times. I tend to use Power Query as much as possible for all the data manipulations and creating summaries (there are some disadvantages there as well).
Yes, data transformation in PQ, calculations in DAX. The only way to learn DAX is to do it often (as most things in life!)
i use both sql and Dax to manipulate data. You can pivot and unpivot with Dax.
Nice explanation 👍👍
Thanks!
Thanks, a lot.
Thanks for the video Ruth !
Yes DAX is difficult. Which information would you like to see while you write a DAX measure to make it easier ?
A lot of the dax filtering is done in the background so it would be nice to make it visible so users now what is going on.
Nicely explained, the beauty but frustration of DAX. I use Analyse with Excel a lot to understand the basic measure and then if the result is weird it helps me to understand if it's my DAX or the filters.
I use excel a lot too to verify my calculations ;)
@@CurbalEN you said in one of your videos that if you don't understand the number the measure gives, then a really good way to learn is work out why, that helped me alot
I follow that religiously!!
Daxstudio helps me a lot to understand the context
To see the filtered tables?
@@CurbalEN , no but to understand the context type. I use the query builder a lot
Can help me?
I have a table with 3 columns Id, Date, Phase. I need to create a column with previous phase for all the current week max date IDs
Can you make a video on line chart,
Requirement is like wanted to show last 12 month data for total sales, provided by condition if any month sales has not been made it should also come as 0 so that the trend will continuous
In database also for oct 2020 and aug 2020 there is no record,but still customer wanted these to come up in the line chart trend
Showing value as 0
Post in the power bi community to get personalized help!
In Excel we have F9 to to break down / Visualize the formulas. DAX don't have that.
DAX requires us to Imagining the different steps - to Read without thinking. The infamous DAX-Wall.
It is good brain training though ;)
It is hard because there is no convenient way to debug "deep evaluations". it's hard to understand what happens in-between each evaluation and tell which values and type (table/column etc) function X just got and what was its output to the next function.
Once you can't really understand what happens in between each evaluation, how you supposed to do something complex? by trying so figure it out for 2 hours? Can you imagine web development without inspect element? can you imagine programming without debugging capabilities? It's like walking in the dark.
There are ways you can see the results of the intermediate calculations, PBI tables, dax studio, .. but none are optimal and you still need to know how your functions work.
Hopefully they wil do something built-in in the future.
Hi @Curbal
Yea... I don't understand how microsoft doesn't develops such tool embedded in Power BI desktop...
It was meany for business users at first, so they have aome catch up to do for developers :(
Is Dificult as Worth It. Thanks Dax Fridays!
Exactly!
Power bi learning is easy but working in real time scenario is not that much easy due to this complex dax
It's hard because no one knows how to teach it. It is always taught through examples and through the UI.
How would you teach it?
@@CurbalEN Pen and paper.
Pen and paper? Now evidence of your claims are requested ;)
Why don’t you take a SSAS model and show us some examples , how to create measures in SSAS model
I dont have an SSAS model to show you.
I found writing measures in SSAS is way more harder . I don’t see anyone uploading videos about SASS models. May be a thing to consider for a future video .
I am afraid I won't be doing any SSAS videos, surely there has to be people doing that?
@@CurbalEN I couldn’t find any... and the way you do the videos is special !
Thanks! Unfortunately SSAS is not my thing ( with the exception on Power BI) . Truly sorry 😐
Como decimos por aquí, el que quiera lapas que se moje el culo.
Si quieres un lenguaje que te haga lo que Dax hace, tienes que esforzarte.
🙂 gracias
😂 buen dicho!