cancel
Showing results for
Did you mean:
Highlighted
Member

## add RANKX to current dax measure

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)```
1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: add RANKX to current dax measure

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
)```
4 REPLIES 4
Community Support Team

## Re: add RANKX to current dax measure

Hi @Route217 ,

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

Regards,

Xiaoxin Sheng

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

For learning resources/Release notes, please visit: | |
Member

## Re: add RANKX to current dax measure

Hi Experts
See attached sample file.

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

Community Support Team

## Re: add RANKX to current dax measure

Hi @Route217 ,

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

Xiaoxin Sheng

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

For learning resources/Release notes, please visit: | |
Member

## Re: add RANKX to current dax measure

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
)```

Announcements

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 35 members 1,120 guests
Recent signins: