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    ...
  • az38's avatar
    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 )