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

thmonte's avatar
thmonte
Helper IV
9 years ago

Anonymous

 

Thanks for the response.  I am going to work on pulling in a table of unique values of date to create a relationship.  Now I asked this in another thread and I haven't gotten a response but it is somewhat related.  I want to use the date slicer to bring in data based on a date range between the two date columns Start Date / End Date.  If you could take a look...

 

https://community.powerbi.com/t5/Desktop/Filtering-within-a-date-range/m-p/227773#M101499

Anonymous's avatar
Anonymous
Not applicable
9 years ago

thmonte,

Since you have created another thread about the date range issue, please close this thread by marking approriate reply as answer. 

The date range issue will be handled by our support engineer in your another thread.

Regards,
Lydia