Forum Discussion

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , if you do not have a date column, Create one like


    date = "01 " & [Month Name] & " " & [year] // change data type to date

     

    Then try a measure like

    Cumm Sales = CALCULATE(SUM(Table[Funding]),filter(allselected(Funding),Funding[Date] <=max(Funding[Date])))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Ideally that should work, I have tried this

      CALCULATE (
      SUM([Funding]),
      FILTER ( ALLSELECTED( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
      )
      But is not working...