Hi Fellow Power BI Users -
I am struggling with something that I thought would be pretty simple, but…
I have already a measure that gives me a percentage-calculation. This measure I use to compare months over months. I now want to compare it to a baseline over a given set of dates: 01012018 to 31072018. My current formula is this:
Baseline = Calculate([Wastage Percentage]; DATESBETWEEN(DimCalendarDaily[CalendardailyKey];date(2018;01;01);date(2018;12;31)))
The result I get is the same as the original measure… it seems that it is not using the datesbetween function.
I use a Calendar table which is related to the fact table from where I derive the original measure.
Any hints to how I get this one working??