Table Transformation in PowerBI

Question

Hi,

I am working on a table like this in PowerBI:

Type Category Date Records Party Activity
MA-HP HP-Aut 6/1/2020 12345 vendor sms
MA-HP HP-Aut 6/1/2020 6534 vendor sales
MA-HP HP-Aut 6/1/2020 234555 client sms
MA-HP HP-Aut 6/1/2020 2234 client sales

I want to transform the above table to look like the one below :

Type Category Date Party SMS Sales
MA-HP HP-Aut 6/1/2020 vendor 12345 6534
MA-HP HP-Aut 6/1/2020 client 234555 2234

Answer 1

Power Bi is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
https://community.powerbi.com/
https://social.technet.microsoft.com/Forums/en-US/home?category=powerbi

--please don't forget to Accept as answer if the reply is helpful--

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.