Forum Discussion

User7664's avatar
User7664
Icon for Helper I rankHelper I
5 years ago

How to filter on a field shared between tables

I have 3 tables for three products. Each table contains a few columns which are similar about all three 3 tables, they are region and type. Each table also has a date column.   I have created a dat...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

User7664 , One option is merge these tables into one.

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

The second is to create a Date Table and common region table and any other common table required and use the tables

https://youtu.be/Bkf35Roman8

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

 

refer-  https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

  • User7664's avatar
    User7664
    Icon for Helper I rankHelper I
    5 years ago

    Thanks Amit,

    I watched your video, very helpful! I wouldnt have thought of using distinct and union. I will work on this tomorrow. 

    I do have two questions tho. 

    1. How would a many to many relationship work? Would it not work at all in this case? In your example if you did a many to many relationship on CityID would it not work?
    2. Are there any cleaner options (that dont involve merging the tables)? If you have 5 or so items that are common on all the tables that is 5 additional tables that need to be created. It will just end up been quite messy. 

    Thanks again. Great video and great help!