Forum Discussion
PowerBI table transform
Hi,
i have a table like above. How can i transform this to something like below so all start and end dates are consolidated to two columns? This will help me build my xviz gantt chart.
disregard my last question. i was able to figure it out. i created another custom column to T&C, SPC1-2, and SPC3-7, then pivoted the columns, which worked!
4 Replies
hpatel123 , step one unpivot all date columns.
Step 2- Split by a delimiter, use option first delimiter in power query (There will 2 columns)
Create a New Column in power query
= if Text.Contains([Part 2 of split], "Start) then "Start Date" else "End Date")
Delete the part 2 column now
select the new column with Start and end date and Date and pivot that
https://radacad.com/pivot-and-unpivot-with-power-bi
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12
Text.Contains: https://youtube.com/watch?v=Hs2q6qcrdgU&feature=share
Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag
If this does not help
Can you share sample data and sample output in table format?Hi,
Share raw data in a format that can be pasted in an MS Excel file.
Thank you amitchandak. Your steps helped me a little to get closer to where i want to be, but not there yet. Below screenshot shows Start and End dates date showing 'null' and additional unnessary rows.
below is 'From' current table 'To' my desired table look on how i'd like to see
disregard my last question. i was able to figure it out. i created another custom column to T&C, SPC1-2, and SPC3-7, then pivoted the columns, which worked!
