Forum Discussion

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Measure Sum For first Days

Hi There  ;   i need your support to create below measure ;   i have a table as below , i need take sum based on first date on my table total amount  as below right    thanks in advance   ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi erhan_79 

    it's easy to re-write the statement from another thread 🙂

    Measure = 
var _minDate = CALCULATE(MIN(Table[Date]), ALL(Table))
RETURN
CALCULATE(SUM(Table[Amount]), ALL(Table), Table[Date]=_minDate )
FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
6 years ago

Hi erhan_79,

see figure:

 

 Regards FrankAT