Forum Discussion

thmonte's avatar
thmonte
Helper IV
9 years ago
Solved

Using Date to filter over multiple tables

I have multiple tables that all have date/time values for each row in the table.  I am looking to create a report and would like to be able to filter over date/time but I do not have a table of unique values to create a relationship from.  In addition I am using DirectQuery which does not allow me to create a summarized table of unique values.  Can anyone point me in the right direction?

 

Thanks in advance.

  • Anonymous's avatar
    Anonymous
    9 years ago

    thmonte

     

    You can make a time dimension without using summarize. Try making a new table with this:

     

    TimeDim = CALENDAR(FIRSTDATE(Table[Date]);LASTDATE(Table[Date])).

     

    Then you can link your tables to this new table, and slice on that. Let me know how it goes.

     

    Best,

    Martin