Need Measure

[erhan_79]

Hi Community ;

ineed your supoort to create below measure ;

i have a table as below , i need take sum based on last date on my table total amount  as below right 

thanks in advance 

[az38 · Accepted solution]

Hi @erhan_79 

try

Measure = 
var _maxDate = CALCULATE(MAX(Table[Date]), ALL(Table))
RETURN
CALCULATE(SUM(Table[Amount]), ALL(Table), Table[Date]=_maxDate )

[erhan_79]

@az38  thank you very much my firend 

[az38]

@erhan_79 

you are always welcome 🤝