Forum Discussion

tomas789's avatar
tomas789
Regular Visitor
7 years ago
Solved

Sorting Matrix sub column by Year

I'm trying to build a matrix that will has these requirements: 1.  Each year should be a sub column under Sales and ASP.   For example |Sales                 | Qty                   | |2017|2018|...
Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    tomas789 ,

     

    You can create a calculate column using DAX like pattern below:

    Rank =
RANKX (
    FILTER (
        Table,
        Table[Category] = EARLIER ( Table[Category] )
            && Table[Qty] = EARLIER ( Table[Qty] )
    ),
    Table[sales ],
    ,
    DESC,
    DENSE
)

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

tomas789 ,

 

You can create a calculate column using DAX like pattern below:

Rank =
RANKX (
    FILTER (
        Table,
        Table[Category] = EARLIER ( Table[Category] )
            && Table[Qty] = EARLIER ( Table[Qty] )
    ),
    Table[sales ],
    ,
    DESC,
    DENSE
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.