Switching between Order date and Ship date

Question

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 which is slowing down my report dramatically. How do I allow a user to select a date range but by the date column they want and have it apply across all measures/data points? Thanks!

lbendlin · Answer

What do you not like about USERELATIONSHIP ?

sefreeman1 · Answer

My understanding of USERELATIONSHIP is that it is on the measure level/calculation only.&nbsp; I'm looking to allow users to look at the same dash but select which date they want to view it by.&nbsp; So I want to see all my measures by order date or I want to see all my measures by ship date.&nbsp; Not necessarily both in the same view.

lbendlin · Answer

Yes, create separate measures and use them in a field parameter.

sefreeman1 · Answer

Then a user has to select every field parameter each time right?&nbsp; 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.&nbsp;&nbsp;

lbendlin · Answer

That sounds like you want to combine this with calculation groups.

Forum Discussion

Switching between Order date and Ship date

7 Replies

Related content

Order switching mid workflow

Alternative to SWITCH ()?

Switch -Containsstring

V-Order & Z-Order

Using Switch