Measure Sum For first Days

[erhan_79]

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 

[FrankAT]

Hi @erhan_79,

see figure:

 Regards FrankAT

[az38 · Accepted solution]

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 )

[erhan_79]

@az38  i have such some issues like that 🙂 

thanksfor supports dear 🙂