Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago
Solved

Need Measure

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 

 

 

 

 

Need Help
  • az38's avatar
    az38
    6 years ago

    Hi erhan_79 

    try

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

3 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi erhan_79 

    try

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