Forum Discussion
1 Fiscal Time Dimension/ 2 Date Columns on Fact
I have a Fiscal Time Dimension I need to leverage to view Ship Date and Pay Date by. Users want to be able to filter Fiscal TIme Hierarchy for Ship Date or Fiscal Time Hierarchy for Pay Date.
I see that I can create relationships (one active/one inactive) between the Fiscal Time Dimesnion and Fact Date on the 2 date columns. Is this the correct approach? Thanks!
You can try that but I don't believe that will work for slicers since only one is active and you generally have to use "USERELATIONSHIP" in DAX to switch between multiple relationships. If that is indeed the case, then just duplicate your Fiscal Time Dimension and wire one up to each table.
2 Replies
- Greg_Deckler
Community Champion
You can try that but I don't believe that will work for slicers since only one is active and you generally have to use "USERELATIONSHIP" in DAX to switch between multiple relationships. If that is indeed the case, then just duplicate your Fiscal Time Dimension and wire one up to each table.
Greg_Deckler - Thanks for the feedback! I went with the approach to use duplicated time dimensions and that worked perfrectly.
