Forum Discussion

erhan_79's avatar
erhan_79
Post 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 )

3 Replies

  • az38's avatar
    az38
    Community Champion
    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 )
    • erhan_79's avatar
      erhan_79
      Post Prodigy
      6 years ago

      az38  i have such some issues like that 🙂 

       

      thanksfor supports dear 🙂