Forum Discussion

hpatel123's avatar
hpatel123
Regular Visitor
3 years ago
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.   ...
Need Help
  • hpatel123's avatar
    hpatel123
    3 years ago

    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!

amitchandak's avatar
amitchandak
Super User
3 years ago

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?