Friday 11 January 2019

Create Rank based on minimum cost if ID is same in Power Bi

Rank_On_minCost_for_Same_ID = RANKX( FILTER( 'Table1', 'Table1'[ID]=EARLIER('Table1'[ID]) ), 'Table1'[Cost], , ASC, Dense )

No comments:

Post a Comment