Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everybody
Can Anybody assist me? I have a table in Power Bi that I uploded. Typical records are as below.
Company Country-Deal-with
Cpy1 USA
Cpy1 France
Cpy1 Belgium
Cpy2 UK
CPy2 France
CPy3 India
CPY2 USA
I would like to have one record per company with different columns. I do not know if PBi can handle.
Company Col 1 Col2 Col3 Col-combined
Cpy1 USA France Belgium USA France Belgium
Cpy2 UK France UK France
Cpy3 India USA India USA
I would highly appreciate your help. Thanks
Solved! Go to Solution.
Hi, @Jaweed
You can try the following steps:
Sample:
Step1:Transpose column in Query Editor
Step2:Use First Row as Headers
Step3:Merge columns
Step4:User Headers as First Row and Transpose columns
Step5:Duplicate columns and split columns
Result:
Finally, to change the name of the first column to what you want.
Is this the result you want? Hope this is useful to you
Please feel free to let me know If you have further questions
Best Regards,
Community Support Team _ Zeon Zheng
Hi, @Jaweed
You can try the following steps:
Sample:
Step1:Transpose column in Query Editor
Step2:Use First Row as Headers
Step3:Merge columns
Step4:User Headers as First Row and Transpose columns
Step5:Duplicate columns and split columns
Result:
Finally, to change the name of the first column to what you want.
Is this the result you want? Hope this is useful to you
Please feel free to let me know If you have further questions
Best Regards,
Community Support Team _ Zeon Zheng
Why would you like to do it? The format you're trying to get the data into is not correct for reports in PBI. It's, of course, easily obtained through Power Query but why the heck would you want to do it? You can easily get the matrix visual to display data like this... The column Col-combined can be obtained easily through a measure as well.