Forum Discussion

Raaassotto's avatar
Raaassotto
Icon for Helper I rankHelper I
5 years ago
Solved

Sum for top dates in table

Please help to make a dax function to sum sales for the top latest 3 dates. For every seller latest dates could be different.  Seller Date Sales,$ John 01.02.2021 50000 John 02.02.2021...
Help me please
  • jppv20's avatar
    jppv20
    5 years ago

    Hi Raaassotto ,

     

    You can try this measure:

    Sales 2 = CALCULATE(SUM('Table'[Sales,$]),TOPN(3,'Table','Table'[Date],DESC))
     
    Result:

     

    Jori

     

    If I answered your question, please mark it as a solution to help other members find it more quickly.

    Connect on Linkedin