Hey Mitchell. I just wanted to say thanks for sharing this and all the others I've seen on UA-cam that you've published over the last few years. The way you teach seems to resonate with me. Personally - I'd love to see some of the intermediate / Advanced level DAX videos in the future so please, by all means indulge us all with them if you can find the time to do so. Cheers to you and the guys.
This is cool! It consists multiple famous / useful DAX expression and the way you explain X function and thought on using select column got me thinking a lot. Good food for thought!
A suggestion: Create a model that has "messy" data. By "messy" I mean data that comes from legacy systems that were not designed that well. I think showing people how to do data cleanup is one of the more under emphasized tasks when we talk about building out data models.
DISTINCTX? DAX click bait lol. Seriously, a great way to explore pairing functions together like Lego pieces to create solutions. Thanks for sharing Mitchell! 🙌
I must be missing something, because I don't get why you use RELATEDTABLE() since the relation goes from the one side to the many, so it already implicitly does that filtering. Wouldn't simply using VALUES( column) work the same way and be even simpler? Also, the column with the `ChildItem` column is a bit misleading, because there is already the relationship on the order ID; so for order 123 I already get the relevant detail rows through the relationship, no need to bother with the `children` column, or summarize() or selectcolumns() over a relatedtable(). Just use VALUES().
![Advanced DAX: Problem, Design, Solution [Heavy Demo]](http://i.ytimg.com/vi/eKgcLcrebzI/mqdefault.jpg)
Hey Mitchell. I just wanted to say thanks for sharing this and all the others I've seen on UA-cam that you've published over the last few years.
The way you teach seems to resonate with me.
Personally - I'd love to see some of the intermediate / Advanced level DAX videos in the future so please, by all means indulge us all with them if you can find the time to do so.
Cheers to you and the guys.
This is cool! It consists multiple famous / useful DAX expression and the way you explain X function and thought on using select column got me thinking a lot. Good food for thought!
Would love to see more advanced and complex dax scenarios. Big fan of your teaching style.
Great video! As usual! Can you also use Values as this will return a single column of unique values if im not mistaken
A suggestion: Create a model that has "messy" data. By "messy" I mean data that comes from legacy systems that were not designed that well. I think showing people how to do data cleanup is one of the more under emphasized tasks when we talk about building out data models.
That cleanup should be done in the data warehouse really, rather than the PBI model.
@@baklava2tummy Ideally, you are correct. But my experience has shown me that is rarely ever done, unless they are forced to do it.
DISTINCTX? DAX click bait lol. Seriously, a great way to explore pairing functions together like Lego pieces to create solutions. Thanks for sharing Mitchell! 🙌
I had really hi hopes in analysing data with Power BI, but I find over and over that I CANNOT rely on PBI’s reliability: I cannot replicate the data!
I must be missing something, because I don't get why you use RELATEDTABLE() since the relation goes from the one side to the many, so it already implicitly does that filtering. Wouldn't simply using VALUES( column) work the same way and be even simpler? Also, the column with the `ChildItem` column is a bit misleading, because there is already the relationship on the order ID; so for order 123 I already get the relevant detail rows through the relationship, no need to bother with the `children` column, or summarize() or selectcolumns() over a relatedtable(). Just use VALUES().
I'd have done this in Power Query by delimiter you can make new rows, then I'd do the merge and revert back
Wow.
Where is distinctX?? See title