Forum Discussion

fahadarshad's avatar
fahadarshad
Helper I
9 years ago

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...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

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

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      9 years ago

      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