Forum Discussion
Post ProdigyTransforming data in Power BI
Hello,
I would like to ask how to transform data in Power BI. I have this situation now in Power BI.
Date are in in column headers. I want that will be like each obj corresponds to date and number.
Obj,ojb,pav, date, number. How to implement this?
Hi Analitika ,
You can achieve it by UNPIVOT function in Power Query Editor, please find the details in the attachment.
= Table.Unpivot(#"Changed Type", {"2022.05", "2022.06", "2022.07", "2022.08", "2022.09", "2022.10", "2022.11", "2022.12"}, "Date", "Value")And you can refer the following links to merge two queries in Power Query Editor:
Append vs. Merge in Power BI and Power Query
Best Regards
3 Replies
- Pragati11
Super User
Hi Analitika ,
Not able to understand exactly what you need here.
Can you share the sample inout data and the output required here?
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- Analitika
Hello,
I wanted to merge two tables.
First table column before merge:
After merge:
Final result also diifers, seems merge gives duplicates.
Hi Analitika ,
You can achieve it by UNPIVOT function in Power Query Editor, please find the details in the attachment.
= Table.Unpivot(#"Changed Type", {"2022.05", "2022.06", "2022.07", "2022.08", "2022.09", "2022.10", "2022.11", "2022.12"}, "Date", "Value")And you can refer the following links to merge two queries in Power Query Editor:
Append vs. Merge in Power BI and Power Query
Best Regards
