Forum Discussion

rkaul's avatar
rkaul
Frequent Visitor
7 years ago

Filter two unrelated tables simultaneously

I have two unrelated tables - 'Member order' table which has order info of all the orders placed by the members with order_date and 'renewal payment' table which has information on membership payment...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi rkaul 

you need to create a date table.

Then relate the date column to the relevant date(s) in your tables.

Create a filter/slicer from the date column/date table.

Enjoy!
A

  • rkaul's avatar
    rkaul
    Frequent Visitor
    7 years ago

    can you elaborate on which relationship I should create after creating the new date table? I'm new to PowerBI. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi rkaul 

      As mentioned.

      Take the date column from the date table. 

      Connect it with the date column(s) from your tables. i.e with payment_date & order_date.

      Cheers!
      A