Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
VAR _COUNT = RANKX (
FILTER (ALL('Table1'),
'Table1'[GP] = EARLIER('Table1'[GP])
&& 'Table1'[INDV_ID] = EARLIER('Table1'[INDV_ID])
&& 'Table1'[MALES_UNDER_35] = EARLIER('Table1'[MALES_UNDER_35])
&& 'Table1'[Start_Date2] >= _start_date
&& 'Table1'[Start_Date2] <= _end_date
),
'Table1'[Start_Date2],
,
ASC,
Dense
)
RETURN
_COUNT
Solved! Go to Solution.
@NilR , Refer nested index by Curbal -https://www.youtube.com/watch?v=7CqXdSEN2k4
Examine the recently added function: Table.AddRankColumn. Has a variety of arguments to handle ties.
Thank you! I am using corp version and it's not updated yet :'( Otherwise this is exactly what I needed!!
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.