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 the date column and simplifying its date format and then relating on that but that did not seem to be the answer.

these are the columns i need to be able to filter on.


These are the tables. I believe what i need to do is create a calendar dax formula but i haven't been able to piece it together yet. Any suggestions are welcome. End goal is to have a single slider that adjusts the metrics i have for each of these tables.





Need Help
  • 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.

2 Replies

  • Dalton948's avatar
    Dalton948
    Frequent Visitor
    2 years ago

    this is my current work around until i figure out how to reduce it to just one slider. I was able to consolodate some of the tables in the relationships where able. Allows me to use 3 date filters instead of 6.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.