Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Current View:
Desired View:
I want all start dates row wise and so the end dates.
Thanks in advance!
Solved! Go to Solution.
@Crazydog , First unpivot data. The split data two columns using the first occurrence and then pivot again using the column have start and end date
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12
Split column and Combine Columns: https://youtu.be/T30H_fe2uAA
@Crazydog , First unpivot data. The split data two columns using the first occurrence and then pivot again using the column have start and end date
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12
Split column and Combine Columns: https://youtu.be/T30H_fe2uAA
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.