Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sum till selected month

Hey there,

 

I want to calculate the total amount till the selected month in the slicer. I´ll show the result in a card.

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , No clear Try like

    Till Date =
VAR _max = MAXX(Allselected('Calendar'), 'Calendar'[DATE] )
return 
CALCULATE (
SUM ( Sales[amount] ),
FILTER ( all('Calendar'),'Calendar'[DATE] <=_max),
)

3 Replies

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

    Anonymous , No clear Try like

    Till Date =
VAR _max = MAXX(Allselected('Calendar'), 'Calendar'[DATE] )
return 
CALCULATE (
SUM ( Sales[amount] ),
FILTER ( all('Calendar'),'Calendar'[DATE] <=_max),
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      It works perfectly, it was what I looking for.  Thank you.

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    6 years ago

    Anonymous 

     

    Please see the DAX below.

    Measure = 
VAR maxdate=max('Table'[date])
return CALCULATE(sum('Table'[value]),FILTER('Table','Table'[date]<=maxdate))

    Hope this is helpful