Forum Discussion

PaisleyPrince's avatar
PaisleyPrince
Icon for Advocate II rankAdvocate II
8 months ago
Solved

Filter two fact tables via the same date table

Hi, I have a single date table which is used to filter a fact table with a project start date and the total fees applicable to that project over a period of years. I now have a new fact table to add...
Need Help
  • Kejmil's avatar
    Kejmil
    8 months ago

    Hi,
    The best approach:
    FactA -> DataTable

    FactB -> DataTable

    Requirements:
    proper key between both tables needed.
    cardinality (many to one (*:1) (date table needs to have unique key)

    Cross-filter direction:
    Single

    Make this relationship active: Yes

     

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
8 months ago

Hi PaisleyPrince ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

 

Best Regards, 
Community Support Team 

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
7 months ago

Hi @PaisleyPrince ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

 

Best Regards, 
Community Support Team