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),
)
amitchandak's avatar
amitchandak
Super 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.