DAX Fridays #202: Improve performance of your DAX models

Happy Friday and Happy Easter!


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

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:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!


************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[samuelmanseau]

A "must see" video ! Essential and very useful for all BI projects ! Thanks !

[officesuperhero]

Even on holidays, you are putting out videos. National holiday today in the US. Thanks!

[Turbo_PilotSky]

Ruth, your video that you post yesterday made my day ! It is essential to have a good laughs and you definitely made me laugh. I am still giggling thinking how hard I was on myself thinking that is it - I can’t even keep my eyes on detail. It is so important to stop being hard and demanding on myself and instead just relax and enjoy the present moments .

[jimfitch]

I didn’t watch yesterday’s video, so not looking for a make-up video today. 🙂 Great lessons here, Ruth. I have zero “big data” needs, but am wired to develop efficient / performant models (only in Excel because we don’t have budget to license PBI for our very small company’s needs). Another terrific training from you — thanks!

[Bharath_PBI]

Thank you. DAX studio numbers size columns are in bytes. Happy weekend ahead!👍

[anurag]

love this channel very informative, thanks a lot

[nawaazr]

Really useful, thanks Ruth! My model has been sluggish recently so I will look into doing this

[HachiAdachi]

...OK, I forgive you for yesterday's stunt. 😉 Thank you, Ruth!

[jjpp]

Mucha gracias, el video me resulta bastante aleccionador y oportuno.
El video de ayer me hizo reir todo el día.

[juansepowerplatform]

Hello great video, I ll try the merge option, seems like a solution for some tables. They are called GUID and are notorious when working with Dataverse tables

[kishore_p]

I think I'm gonna stick with the 'Shake it' method! 😄

[natsarev]

I'm still shaking my laptop and it works great! :))

[thomasivarsson]

Strings and high selectivity columns are evil and bad for performance in PBI models.