RANK values for specific value from row cell within table - RANK + Filter

[Anonymous]

Hi all,
I am unable to find specific answer on this forum of Google, so I would be greateful if you can assist or point to best post.

I have a dataset with Names of people and their login dates.

I am trying to create column calculation that will give me ordinal numbers of their login dates, ranked per date (e.g person 1 logs for the first time on March 1 = 1, 2nd time on March 2 =2...)

I know how to make this using VAR + RANK + FILTER in PowerBI, but I am using POWER PIVOT with Excel 2013, and VAR is not working for me.

I tried various options using RANK + Filter, but nothing got it right for me.

Regards

[amitchandak · Accepted solution]

@Anonymous , Not very clear. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

You can create Rank like, A new column

rank = rankx(filter(Table, [person] =earlier([person])), [login date],,asc,)

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

[Anonymous]

Hi @amitchandak , this has actualy solved for me.

Thanks a lot!