Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Transpose mapping between two tables in Power BI

Hi All,

 

I have table 1 where we have age, Gender, Country ,Date and City fields. But these 4 information have been entered by different users in different manners. For eg. Alan have entered age in Field1 where asChris have entered Country in Field1 and so on.

 

 

In Table2 - we have actual field which will map with Main Field and we can identify for eg. Field1 for Alan is Age and Field1 for Chris is Country.

 

Provided the expected output below:

 

How to achieve this in power bi? or How to align age, Gender, Country ,Date and City fields?

 

Thanks in Advance

 

Regards,

Prakash M

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak ,

       

      I have 2 rows for Alan in Table 1 thus i am getting error and if i delete one of those 2 rows and then if i execute all the steps as per your suggetion then it is working. Could you please explain me in detail on how to get the expected output for 2 rows for single process.

       

      Thanks in Advance

      Prakash