Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

indexing

Hi everyone, I have a problem and cannot solve We have 2 offline shops, Shop A and Shop B, every shop have its own sales sorted by date. I want to index that sales by date and by shop.    ex...
Need Help
Show and Tell
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    One way could be to use  a calculated column

     

    Column =
RANKX ( FILTER ( Table1, [Shop name] = EARLIER ( [Shop name] ) ), [Date],, ASC )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Anonymous

 

One way could be to use  a calculated column

 

Column =
RANKX ( FILTER ( Table1, [Shop name] = EARLIER ( [Shop name] ) ), [Date],, ASC )
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    thank you, appreciate