Forum Discussion
Combining measures with diffent calendars
Hi Robbe,
I came also across this solution https://carldesouza.com/power-bi-dax-userelationship-multiple-dates/ Is this what you mean?
So creating new measures using a non active relationship?
Hi there,
This is possible using 1 Date Dimension.
You can create the extra relationships in your model, they will automatically become NON-Active relationships.
Not active doesnt mean you cannot activate them in a measure.
ex. In a Calculate measure you can do the following:
CALCULATE( SUM(SALES); printdate = "2018"; USERELATIONSHIP(DATEKEY,PRINTDATE))
This will use the required relationship.
I hope this helps!
Robbe
Hi Robbe,
I came also across this solution https://carldesouza.com/power-bi-dax-userelationship-multiple-dates/ Is this what you mean?
So creating new measures using a non active relationship?
That's exactly the solution the both of us suggested, yes.
If you have further problems implementing it, feel free to follow up here.
