DAX Fridays! #66: TREATAS

[@rrrprogram8667]

Good explanation ruth..... I was reluctant to learn this function..but now you made it easy...

[@CurbalEN]

Excellent! You have no idea how happy that makes me :) Fills the purpose for the video! Have a happy weekend! /Ruth

[@chavelooo33]

Nice explanation, so simple and goes straight to the point since begging

[@soumikmishra7288]

So simple to understand once you took out that TREATAS part. Thank you again :)

[@waltertiggeloven]

Found this one today: also a nice gift to the world. Love it, thanks you!

[@christopherhastings2142]

Thank you for your exceptional clarity!

[@CurbalEN]

Yey!!! Glad it helped :) /Ruth

[@rolandotemporale791]

Hi Ruth, this is a very useful stuff for the Budget/Sales reports type. Thank for your explanation!

[@CurbalEN]

Yes, absolutely magic!! Loving DAX already? ;) /Ruth

[@rolandotemporale791]

Yes, I love DAX and M also !!

[@CurbalEN]

Me too 😊 /Ruth

[@stephaniegiovannitti7758]

Thank you for breaking that one down so nicely!

[@CurbalEN]

My pleasure 🤗 /Ruth

[@slakha000]

good explanation. Simple but yet very powerful example!

[@CurbalEN]

Oh great! I really wanted to explain it clearly because it is such a great function! /Ruth

[@AHMEDALDAFAAE1]

Great explanation.. Thank you Curbal

[@CurbalEN]

Glad to hear ;) /Ruth

[@germantejeria3677]

I just saw this video again, after a year, and I'm still fully shocked by the way you Ruth has explained such a hard task, it's amazing what we can do using TREATAS !! THANKS!!

[@CurbalEN]

🥳🥳🥳

[@juancarlosfigueroafigueroa943]

Hi Ruth need your help with a dumb problem? I have an order report published on a PBI app. A person can be first or second seller in an order and the report has RLS over the orders and linked to the seller code. My fact table has separate columns with first and second seller code. I just figured out that they can only see their first sales orders but I had a measure with their second seller orders wich they can't see due to the RLS auto filtering. I need your DAX magic! The second seller measure is a calculate with an ALL over salesman dimension table and a TREATAS with the actual seller code (VAR) to transform it to the second seller code.

[@RobertoStaltari]

Pulgares arriba¡! Gracias Ruth

[@CurbalEN]

👍👍👍 :) /Ruth

[@bradj229]

Great video as always. Thanks! :)

[@benignoguilarte2806]

Ruth this is just Great!! this video make my day. Thanks and keep going with your wonderfull videos

[@CurbalEN]

Yey!!! Wonderful and you just made mine :) /Ruth

[@holahandstrom]

Brilliantly simple explanation. Much better than the sqlbi-guys. ...and to showcase 'New Table' as Excel's F9-button. Think if PowerBI could invoke a 'New Table' from F9.

[@CurbalEN]

Hi Ola! Their explanation goes deeper and it is more technical. I over simplify things, just to get the main point across, to lose the fear for the function and dare to go wild with it. Mmmmm F9?? I didn’t know there was a F9 shortcut for it, thanks! I will pin your post for excel users :) Happy weekend! /Ruth

[@stephaniegiovannitti7758]

sqlbi-guys do tend to over complicate their explanations, IMHO. great skill Ruth has in helping us break it down into a simple explanation

[@CurbalEN]

I think we serve different audiences. Their explanations are more technical and correct and for those who need to dig deeper. My explanations are more for beginners and excel users that want to get started. Together we hopefully pave the DAX path for everyone :) /Ruth

[@stephaniegiovannitti7758]

Lol. Good point. DAX for everyone. sqlbi is a good resource for sure.

[@learnspreadsheets]

Thanks! This use case seems different to quick measures, do you know how it’s used in quick measures the {( confuse me!

[@CurbalEN]

I don’t use quick measures so I can’t tell. Try asking the author of the measure! /Ruth

[@roberttyler2861]

Hi Ruth, Thanks for this explanation! How could you extend this further to include a parameter? Like territory? Thanks!

[@CurbalEN]

Hi Robert, could you ask in the power bi community? No time to check that,Thanks! /Ruth

[@rrrprogram8667]

TREATAS() is not available to use in Excel power pivot :'(

[@CurbalEN]

Oh no!! That su&**s! /Ruth

[@longbaonguyen6099]

You can use INTERSECT function in Excel power pivot

[@rpopecpa]

I tried to follow along with your example in Excel 365. TREATAS() still does not appear to be available.

[@KR-good]

Watching this today and making a note to use "it's just like when you want to eat an elephant; you have to cut him into small pieces" to make a point. 😃

[@CurbalEN]

Very relatable experience indeed 😂😂

[@frankgovers8420]

Wow

[@CurbalEN]

Good isn’t it? Happy Friday :) /Ruth

[@Phoenixspin]

Please, let's not eat elephants. We have to chop the lettuce into pieces in order to make a salad. That's better. I will work on understanding and using this function. Seems like a game changer to me.

[@CurbalEN]

😂😂

[@oliveroshea5765]

A* as usual!

[@CurbalEN]

👏👏