How do I solve this simple data modelling problem in Power BI

[fahadarshad]

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

[v-yulgu-msft]

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 Gu

[fahadarshad]

Hello 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]

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