Forum Discussion

NilR's avatar
NilR
Post Patron
3 years ago
Solved

Ranking in Power Query

I have Dax Rankx and would like to convert into M query ( power Query), is it possible?       Ranking Measure= var _end_date = 'Table1'[Start_Date2] var _start_date = EOMONTH(_end_date,-24)+1 V...
Need Help
ronrsnfld's avatar
ronrsnfld
Super User
3 years ago

Examine the recently added function:  Table.AddRankColumn.  Has a variety of arguments to handle ties.

NilR's avatar
NilR
Post Patron
3 years ago

Thank you! I am using corp version and it's not updated yet :'( Otherwise this is exactly what I needed!!