add RANKX to current dax measure

[Anonymous]

Hi Experts

have a little trouble in added rankx to the current measure...so the 1/7/2019 is value 1 and the oldest date 36..

Table 2 = ADDCOLUMNS(FILTER(CALENDAR(MIN(PMS_FINANCIAL_PDS[Month Start]),MAX(PMS_FINANCIAL_PDS[Month Start])),DAY([Date]) =1),
        "CountComplaints", CALCULATE(COUNTA(PMS_COMPLAINT[MATERIAL_ID]),
            FILTER(PMS_FINANCIAL_PDS,PMS_FINANCIAL_PDS[Month Start].[Year] = YEAR(EARLIER([Date]))
                && PMS_FINANCIAL_PDS[Month Start].[MonthNo] = MONTH(EARLIER([Date]))))+0)

[v-shex-msft]

Hi @Anonymous ,

If you can please share some sample data with expected result, it will be help for test and coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Experts
See attached sample file.

link: https://www.dropbox.com/s/ne2pk1eehazyvce/Sample__v.1.13.pbix?dl=0

Rank the values with most current date as 1 and oldest date as 36.. see table 2 in attached pbix file for your data.

[v-shex-msft]

Hi @Anonymous ,

Sorry for late response, I try to access your link but it seems expired. Can you please renew and share it?
Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi Xiaoxin Sheng

I have managed to solve the problem using the following DAX and Amend my orginial DAX formula. Much Appericated for all the support you guy provide.

Index = 
RANKX(
    PMS_FINANCIAL_PDS,
    PMS_FINANCIAL_PDS[Month Start],,,
    Dense
)