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

Thanks a lot Anonymous ,

 

I added measureB sumx (Format:numbers) to the report and now I want to add another MeasureC to the report.

 

MeasureC

Shall be the variance (var.p) for every "Customer and Material" combination like the rankx.

Unfortunately var.p needs a column and don't work with measureB.

 

Can somebody help me out here? 

 

 

CustomerMaterialOrder Date

MeasureA

Rankx

(based on your filter formula)

MeasureB

Sumx

(based on your filter formula)

MeasureC

Var.P("on MeasureA")

based on 

A1231.1.2019   
A12310.1.2019   
B......   
B     
C     
C     

 

Thanks

lanko

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous ,

 

Try 

 

Measure = VARX.P(ALL(Table3),[Ranking])
 
 
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!