Forum Discussion
Solved
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!
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