How To Create Self sorting Columns In Power BI

Subsequent to a recent DAX pop quiz that I prepared and posted on LinkedIn, Pavel Adam, one of the people who responded to the quiz raised a fascinating idea, via which text columns no longer needed a numeric sort column to put them in proper order. I experimented with Pavel s approach and it worked beautifully. In today s video, I show how using that approach you can create selfsorting text columns using both DAX and Power Query. Brian Link to Solution: Video Details 00:00 Introduction 01:03 The goal 02:43 Extended date table 03:31 Power Query solution 04:10 04:36 06:58 DAX solution 07:28 REPT 09:06 Visual application Related Links Hidden DAX Trap Learning Power BI FREE COURSE Ultimate Beginners Guide To Power BI