This was helpful. True story - I'm so dumb, that until recently,I used to spend time in PQ sorting AND arranging columns. Did a lot of things that broke query folding and caused slowdowns. Then one day I asked myself, why am I trying to get my data all neat in PQ? Who cares... take care of it in the visuals. But as you said, sometimes sorting is necessary to further transform your data - but apart from that, I stopped sorting and I stopped arranging columns.
Thank you (from the U.S. of A.). That is an incredibly nice thing for you to say. I'll try not to let you down in future videos. Thanks for watching and your support. Cheers.
Thanks for the video. I was mystified why, when combining CSV files, where the primary column is consecutive days, or date and time at set intervals, the rows become jumbled up when loaded into Excel.
I've seen this with the data model, but never knew the nuts and bolts as to why. I won't get mad at it anymore. How did you figure out that it is a memory management strategy by way of the various encodings?
This was helpful.
True story - I'm so dumb, that until recently,I used to spend time in PQ sorting AND arranging columns. Did a lot of things that broke query folding and caused slowdowns. Then one day I asked myself, why am I trying to get my data all neat in PQ? Who cares... take care of it in the visuals.
But as you said, sometimes sorting is necessary to further transform your data - but apart from that, I stopped sorting and I stopped arranging columns.
@@Quidisi Glad you found this helpful and that the lessons are valid. Save that time for other things, like visuals refinement. Thanks for watching.
Greetings from Egypt , since the first time I saw I video for you I decided to watch whatever are your posting on YT because you are smart
Thank you (from the U.S. of A.). That is an incredibly nice thing for you to say. I'll try not to let you down in future videos. Thanks for watching and your support. Cheers.
Awesome! Very interesting and helpful. Thanks Professor.
@@JuanCVazquez-s9k Glad you found it useful. Thanks for your comment.
Great video which clear the unclear issue of sorting and removing duplicate row to get the latest record. 👍👍
Thank you! I thought I was going mad for a while when witnessing this behavior. Cheers.
Interesting video and explanation of data compression techniques.
Thank you. I appreciate your viewership and support.
Fascinating! Many thanks. 😊
@@iankr Glad you like it. Thanks to you, too.
Excellent explanation
Thanks again!!! Glad you found this helpful.
Interesting, thanks! I never really noticed this
@@chrism9037 Things that make you go “hmmm”. Thanks for watching and commenting.
Thanks, very helpful, professor. It seems to be the reason why we need Table.Buffer when Group by depends on sort order...
@@kkravch Yes, that could very well be. Thanks for watching.
'Now you understand' yeah right, this is going to take just a few more re runs.
@@williamarthur4801 Watch it 100 more times. It helps my view count. 🤣
Thanks for the video. I was mystified why, when combining CSV files, where the primary column is consecutive days, or date and time at set intervals, the rows become jumbled up when loaded into Excel.
Exactly! I was puzzled for the longest time over this behavior. Thanks for watching.
I've seen this with the data model, but never knew the nuts and bolts as to why. I won't get mad at it anymore. How did you figure out that it is a memory management strategy by way of the various encodings?
@@jasongins By reading a VERY long and in-depth book named “The Definitive Guide to DAX” by Marco Russo and Alberto Ferrari. Thanks for watching.