DAX Row Number based on two columns (Calculated Column)

Question

Hi All,Thanks in Advance.&nbsp;Guide me on this.&nbsp;&nbsp;DAX - Calculated&nbsp;Column(No Measure)&nbsp;RowNumber/Rank based on Year-MMM and Customer by Amount desc&nbsp;Monthwise customer rank/row number by Amount desc order&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Hi,&nbsp;I may understand you correctly. I have 2 calculated columns for rank:Rank All column by amount:Rank All = (RANKX(Q3,Q3[Amount],,DESC,Skip))&nbsp;Another rank is by MonthYear:Rank by MonthYear =&nbsp;(RANKX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER(Q3,Q3[MonthYear] = EARLIER(Q3[MonthYear])),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Q3[Amount],,DESC,Skip))&nbsp;&nbsp;I hope this help and solve your problem. Thanks.&nbsp;Duc&nbsp;

Forum Discussion

DAX Row Number based on two columns (Calculated Column)

2 Replies

Related content

TMDL - calculated column

Direct Lake Model - Calculated Column/Tables

Power Query or Calculated columns

IF calculated column

Dynamic Variable in Calculated Columns