Forum Discussion

JuanVR11's avatar
JuanVR11
Icon for Helper I rankHelper I
6 years ago
Solved

Add a column for cumulative counting row

Hi Friends! I hope u can help me with this issue. I´m looking for a dax formula in a calculated column.   As you can see i have a table with SalesDoc / Pos / Material columns, and i want to calcul...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    JuanVR11 

     

    Please try below measure

    Column = RANKX(FILTER('Table (2)','Table (2)'[material]=EARLIER('Table (2)'[material])),'Table (2)'[date],,DESC)

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

JuanVR11 

 

Please try below measure

Column = RANKX(FILTER('Table (2)','Table (2)'[material]=EARLIER('Table (2)'[material])),'Table (2)'[date],,DESC)

JuanVR11's avatar
JuanVR11
Icon for Helper I rankHelper I
6 years ago

It works!

Thanks a lot my friend.