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 self-sorting 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 -