Forum Discussion
Raaassotto
Helper I
Helper ISum 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...
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
jppv20
Solution Sage
Solution SageHi 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