Connect data from lookup in table1 to a col in table2 to show data on basis of date and lookup col

[Avinash_Sah]

I have multiple data sources most of which is connected to a date table for date sync. 

One of them is not connected with date and has a lookup from another table (brand id to brand).

The lookup column is connected to another table that has the column with same brands.

I created relationship between them on the basis of brand, but when date filter is applied the data is not getting filtered.

Also some of the brands are missing. I want zeros in both the columns where that brand is missing.

Any related help would be Appreciated.

[amitchandak · Accepted solution]

@Avinash_Sah , to me it seems like you need common tables

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

Or check 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[Avinash_Sah]

Hi thanks for answering, What I want to achieve is also use the second column in the table "category" similar to "brand" but as now the connection is made on brand it shows errored data on category basis. Any way to connect that?

[Avinash_Sah]

Solved using a copy of same table and doing all of this again. Thnx for the help btw