Creating Dense_Rank() Partition in Power BI with Numbered Rankings

[Anonymous]

Hi

I want to create measure in power BI which would allow me to rank() the number of times ID would appear in  table by that ID created date. I would like the ID to be ranked in desc order. 

For example 

 if I was to produce this in SQL then the code I would use is.. 

DENSE_RANK() over(partition by [OwnerID],order by [CreatedDate]) END AS RankJob

Appreciate the responses.

[V-pazhen-msft]

@Anonymous 

So you want to rank the date by ID:

measure = RANKX(ALLEXCEPT('Table','Table'[ID]),CALCULATE(SUM('Table'[Date])),,ASC,Dense)

Paul Zheng
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

[Anonymous · Accepted solution]

Thanks for the responses.

I have figured out the solution to the issue. Solution was found here in the following link.

https://community.powerbi.com/t5/Desktop/Rank-based-on-date-for-each-individual-user/td-p/411053

[Anonymous]

J

[amitchandak]

refer , if this can help

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601