Forum Discussion

anandav's avatar
anandav
Skilled Sharer
7 years ago
Solved

Sorting by multiple columns

Hi Experts,   I have the following data.   Employee Training Date Greg Training 1 19/09/2017 Bill Training 1 19/09/2017 Joe Training 1 19/09/2017 David Training 1 19/09/2017 ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    anandav,

     

    You may try using ISONORAFTER Function to add a measure.

    Measure =
VAR t =
    SUMMARIZE (
        ALLSELECTED ( Table1 ),
        Table1[Employee],
        Table1[Training],
        Table1[Date]
    )
RETURN
    COUNTROWS (
        FILTER (
            t,
            ISONORAFTER (
                    Table1[Employee], SELECTEDVALUE ( Table1[Employee] ), DESC,
                    Table1[Training], SELECTEDVALUE ( Table1[Training] ), ASC,
                    Table1[Date], SELECTEDVALUE ( Table1[Date] ), DESC
            )
        )
    )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

anandav,

 

Sorting in Power Query can be used in later steps.