Forum Discussion
Switching between Order date and Ship date
I've seen a few options on how I can select between two different date columns on the same row but they all go back to "userelationship" or an "if" statement that is needed for every single measure w...
What do you not like about USERELATIONSHIP ?
My understanding of USERELATIONSHIP is that it is on the measure level/calculation only. I'm looking to allow users to look at the same dash but select which date they want to view it by. So I want to see all my measures by order date or I want to see all my measures by ship date. Not necessarily both in the same view.
Yes, create separate measures and use them in a field parameter.
Then a user has to select every field parameter each time right? i.e. Margin - Ship date, Trailing 7 days Margin - Ship date, Rev, YTD Rev, etc. instead of just clicking "ship date" and all metrics changing.
