Forum Discussion

Acamara's avatar
Acamara
Frequent Visitor
5 years ago
Solved

Creating a Ranking according to a date

Hello Guys.   I've been stuggling with creating Ranks for several products in different months.   I have a table which has different products, different months and serveral sales per month. What ...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Acamara 

     

    Create a calculated column to extract the month in the date,

    _Month = MONTH ( 'Table'[Date] )

    Then, try to create a measure like below:

    _Rank measure =
RANKX (
    ALLEXCEPT ( 'Table', 'Table'[_Month] ),
    CALCULATE ( SUM ( 'Table'[Sales] ) ),
    ,
    DESC,
    DENSE
)

    I created a simple sample to illustrate this.

    Sample:

    Result:

    Please refer to the attachment below for details

     

     

    Is this the result you want? Hope this is useful to you

    Please feel free to let me know If you have further questions

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Fowmy's avatar
Fowmy
Super User
5 years ago

Acamara 
Does your model have a dates table ?

Please share data in CSV or Excel format, it will help me create a solution faster. You can save in OneDrive or any other cloud drive and share the file link here.