Forum Discussion
How 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 sector, event, user connected to tables 1,2,3.
Then I have the targets(5) in terms of revenue per sector, event, user connected to tables 1,2,3.
I need to build a single table from all these tables.
Regards
3 Replies
Hi fahadarshad,
According to current description, it's not very clear about your requirement. Please share some sample data from original tables. If possible, please provide the screenshots of current tables and your desired single table so that I can understanding the table structure. Also, please tell us the relationships between all these tables.
Best regards,
Yuliana GuHello 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.
Hi 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
