Forum Discussion
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...
NilR , Refer nested index by Curbal -https://www.youtube.com/watch?v=7CqXdSEN2k4
NilR , Refer nested index by Curbal -https://www.youtube.com/watch?v=7CqXdSEN2k4
I ended up using this technic since nothing else is working but I also added below line to my sql:
DENSE_RANK() OVER (PARTITION BY GP, INDV_ID,MALES_Under_35 ORDER BY YRMO ASC ) AS Active_MOS