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),
)
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