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

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

     

    Since I am using DirectQuery I am uanble to create a new table.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      thmonte,

      You would need to create the summarized table that contains unique values in your source, and import the table to Power BI Desktop, then link your tables to the new table.


      Regards,
      Lydia

      • 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