Forum Discussion
Solved
SharePoint date data to tabular date hierarchy
Hello, I have a PBI report receiving data from a SharePoint list that manages our internal meetings. Someone in leadership doesn't like the default view of the Topic name followed by the 3 or 4 meet...
Yes. In Power Query you will want to UNPIVOT the data. In Power Query, highlight the four Meeting columns, then click UNPIVOT and select "Unpivot columns".
If you think you might get additinal columns down the road, select the FIRST column and do "Unpivot Other Columns"
Hope that helps
Yes. In Power Query you will want to UNPIVOT the data. In Power Query, highlight the four Meeting columns, then click UNPIVOT and select "Unpivot columns".
If you think you might get additinal columns down the road, select the FIRST column and do "Unpivot Other Columns"
Hope that helps
