Forum Discussion

Dalton948's avatar
Dalton948
Frequent Visitor
2 years ago
Solved

Single Date Filter for multiple Tables that do no relate.

I have 6 Tables each with completely different data and the only thing i want to filter on between them is the date to get a snap shot of statistics for a current time period. I tried copying th...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Dalton948 ,

    If I understand you correctly, each of your tables contains a date column, and then you want to filter the data in all the tables by a date slicer.
    I recommend that you add an additional Calendar table that contains all the dates covered in the other tables. Then create a relationship between this table and the other tables.
    Here is my sample data:

    And I use this DAX to create the Calendar table (The date span in my sample data is 2024.1.1-2024.4.10):

    Calendar Table = CALENDAR(DATE(2024, 1, 1), DATE(2024, 4, 10))

    Then create relationships between these tables:


    Use the Calendar Table to create the slicer and the final output is as below:


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.