BojeErvenius
New Member
- Joined
- Mar 7, 2014
- Messages
- 14
Hello,
I have a Power Pivot model with one calendar table. I have 4 relationships between a fact table and the calendar table. I have about 50 measures. What I would like to accomplish is that these measures could be viewed in a pivot table based on different calendar dates.
I know that I can use the function USERELATIONSHIP in the measure. But does that mean that I have to create 50*4 measures?
I also know that I can create a table with my 4 dates and then use a slicer on that table so that the user have to select a datetype. Then I create a measure that checks what is chosen. And then in all my measures I use an IF function to control what relationship to use in USERELATIONSHIP based on the “datemeasure”.
But, there must be some better way to handle this. I have searched the internet but can’t find anything. Am I missing something obvious? For example, is there no simple way that the user can make a selection to activate a relationship, without doing it themselves in the model.
I have a Power Pivot model with one calendar table. I have 4 relationships between a fact table and the calendar table. I have about 50 measures. What I would like to accomplish is that these measures could be viewed in a pivot table based on different calendar dates.
I know that I can use the function USERELATIONSHIP in the measure. But does that mean that I have to create 50*4 measures?
I also know that I can create a table with my 4 dates and then use a slicer on that table so that the user have to select a datetype. Then I create a measure that checks what is chosen. And then in all my measures I use an IF function to control what relationship to use in USERELATIONSHIP based on the “datemeasure”.
But, there must be some better way to handle this. I have searched the internet but can’t find anything. Am I missing something obvious? For example, is there no simple way that the user can make a selection to activate a relationship, without doing it themselves in the model.
