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
            )
        )
    )
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi All,

 

Wonder if you can help?

 

I have data that I want to sort specifically, I was told there was a measure for it.

 

Basically on excel you can move the columns on the pivot table. So i can have 0-7,8-13,14-20 in order ( 8-13 always defaulting a date) so when i create a pivot, the order is 8-13, 0-7, 14-20.

 

How am I am to change the order in Power BI?