Forum Discussion
Sum by year
Dear Friend,
i have two tables, data(value,id,..) and calendar(date,year,quarter) and are related one to many .
i have date slicer between and calculated profit by measure:
var date_min=CALCULATE(min('Calendar'[Date]),ALL('Calendar'[Date]))
var date_max=CALCULATE(MAX('Calendar'[Date]))
return
CALCULATE(SUM(JDT1[Value]),DATESBETWEEN('Calendar'[Date],date_min,date_max))
its working fine on any visual with category axis.But when i show visual with x axis Year,Quarter. its give wrong data.
could you please help how i can short out.
1 Reply
This bit is not behaving as you're expecting:
ALL('Calendar'[Date])
It only removes filters directly applied to that column. If the quarter or year columns are filtered, it will do nothing. I recommend replacing it with ALL('Calendar'). You are not alone in having this issue. Here's someone else having a similar problem:
https://community.fabric.microsoft.com/t5/Desktop/Cumulative-sum-with-Date-Hierarchy/m-p/797893
