Forum Discussion
Activity column with multiple week ending schedule dates
Hi,
I have a data set for a commissioning schedule i woud like to get into power bi. I have one column with the activity/task and multiple columns with week ending dates that get filled as job progresses.
Any idea how i can link my Dates table to the Summary table containing Activity/Task Description and Week Ending columns?
The goal is to create a dashboard so when training dates or due dates are coming up, individuals needing to attend training can easily open up dashboard and see dates in a matrix or table type of scenario.
Link to data set below:
Thank you!
2 Replies
- amitchandakSuper User
PabloGiraldo , Select the first column and use unpivot other columns in power query
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Learn Power BI: Power Query Table.Unpivot, Table.UnpivotOtherColumns: https://youtu.be/0FEGEAz9UMw
- PabloGiraldoHelper IV
amitchandak Screenshot below is similar how i would like my table or matrix to look.