Hi Sam and others
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];
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??