Creating a Relationship

[Anonymous]

Hi everyone,

I am trying to create a relationship between two tables but I am unsure as to how because I dont have any unique id and BI many-to-many relationship is not working well

Total Money

Date	Company	Manager	Total
01-Jan-18	USA	Obama	100
01-Jan-19	USA	Trump	200
01-Jan-20	USA	Biden	300

Money flow

Date	Company	Manager	Money In	Money out
01-Jan-18	USA	Obama	20	20
01-Jan-19	USA	Trump	50	20
01-Jan-20	USA	Biden	100	20

This is to create a  line and cluster graph that shows the total money as a a line and the money in/out as bars. Currently the totals are correct but once you filter it gives the wrong data

Any ideas?

[amitchandak · Accepted solution]

@Anonymous , Create three common table date, Company, Manager and then you can analyze them with help from common dimensions

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

https://www.youtube.com/watch?v=Bkf35Roman8