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
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