Forum Discussion

smp0150's avatar
smp0150
Frequent Visitor
9 years ago
Solved

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 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

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.

  • smp0150's avatar
    smp0150
    Frequent Visitor
    9 years ago

    Greg_Deckler - Thanks for the feedback! I went with the approach to use duplicated time dimensions and that worked perfrectly.