Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Issue using isonorafter () and a Date Var

Hello guys!. Im trying to plot an accumulative sum based on the last date entered in a DateField Box. My plot has to show all the months of the current selected year (for example: if i pick 01-jun...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try a measure like

 

Cumm =
var _max = maxx(allselected('Date'), 'Date'[Date])
return
CALCULATE(COUNTA('Tareas'[Tare_Fech_Prog]),filter(all('Date'),'Date'[Date] <=max('Date'[Date]) && year('Date'[Date]) = _max))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak , thank you for your reply!

I did it but it shows nothing.