Forum Discussion
fahadarshad
Helper I
Helper IHow do I solve this simple data modelling problem in Power BI
Hello everyone So here is my data model The unique values of each sector(1), event(2) and user(3) are coming from their master tables. Then I have the achievements(4) in terms of revenue per...
fahadarshadHelper I
Helper IHello Yuliana
Thanks for your help.
Here is the link to the sample data sets
https://www.dropbox.com/s/mz4gubzwkjz57e6/sample%20data.xlsx?dl=0
It has the relationships and the tables there.
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi fahadarshad,
Are these relationshipts all one to one type?
If you want to create a single table in visual mode by creating calculated tables, you can use LookUpValue function.
If you want to change the source data model in query editor mode, you can Merge these tables.
Regards,
Yuliana Gu