Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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!
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
Hi,
Share raw data in a format that can be pasted in an MS Excel file.
@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?
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |