Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rankx with Dates

  Hi all,    I have the table like that and want to create a report with a RankX     Customer Material Order Date RankX A 123 1.1.2019 1 A 123 1.1.2019 2 A 123 3.3.2019 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

     

    Create a Calculated Column

     

    RANK Column = RANKX(FILTER('Table','Table'[Customer] = EARLIER('Table'[Customer]) && 'Table'[Material]= EARLIER('Table'[Material])),'Table'[Order_date],,ASC)
     
     
     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous,

 

thanks for the quick reply. I'm talking about the rankx formula. 

 

I created the table: Report_Table

Report_Table = SUMMARIZE(table1;table1[customer];table1[material];table1[Order_date])

 

Ranking1(calculated column):

Ranking1 =

var a = MAX(Report_Table[customer])
var b = MAX(Report_Table[Material])

return

RANKX(FILTER(ALL(Report_Table[Soldto_number];Report_Table[Material_number];Report_Table[Order_date]); Report_Table[customer] = a && Report_Table[customer] = b); CALCULATE(MAX(Report_Table[Order_date]));;ASC;Skip)

 

Report_table:

CustomerMaterialOrder_dateRanking1
A1231.2.20191
A1235.2.20191
A1236.3.20191
A1241.2.20191
B12310.4.20191
B12315.6.20191
C1243.8.20191
C12415.9.20191

 

So basically the ranking is not working like that. 

Do you have an idea on that? 

 

BR

Lanko

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

 

Create a Calculated Column

 

RANK Column = RANKX(FILTER('Table','Table'[Customer] = EARLIER('Table'[Customer]) && 'Table'[Material]= EARLIER('Table'[Material])),'Table'[Order_date],,ASC)
 
 
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

  • powerbifuddaa's avatar
    powerbifuddaa
    Icon for Helper II rankHelper II
    2 years ago

    Hi all, Hi Harsh,

    Great formula. Any idea how I can achieve this:

    Thanx for your help!

    Regards, Elmer