Forum Discussion
Issues with EOMONTH
This formula: Assigned last year = CALCULATE([Case count], USERELATIONSHIP('calendar'[Dates],'All cases combined'[Date assigned]), DATESINPERIOD('All cases combined'[Date assigned], EOMONTH(T...
PhoebeK , there nothing in screenshot one. Screenshot 2 is not having axis. What is missing.
eomonth(today(),-2) mean Jan -22 (we are in march now)
and rolling data for 12 month
also check
Rolling 12 Sales =
var _max = maxx(allselcted(date),date[date]) // or today()
var _min = date(year(_max), month(_max)-12,1)
return
CALCULATE(SUM(Sales[Sales Amount]),filter(date, date[date] <=_max && date[date] >=_min))
or
Rolling 12 Sales =
var _max = eomonth( today() ,-1) // eomonth( today() ,-2)
var _min = date(year(_max), month(_max)-12,1)
return
CALCULATE(SUM(Sales[Sales Amount]),filter(date, date[date] <=_max && date[date] >=_min))