Forum Discussion
Solved
Unpivot through M or ease
I have below dataset. Student Course1 Course2 Course3 Course1 Course2 Course1 Course2 Course3 Course1 Course2 James 01/02/2019 12/08/2000 Not Compliant Not Compliant Y N Y ...
Junaid11 , In the first table which has course number, add a prefix or a suffix to give meeting what it is
| StartDate Course1 | StartDate Course2 | StartDate Course3 | Compliant Course1 | Compliant Course2 | Status Course1 | Status Course2 | Status Course3 | EndDate Course1 | EndDate Course2 |
Now unpivot all these columns. https://radacad.com/pivot-and-unpivot-with-power-bi
Split by Delimiter (first only) into 2 column https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
the pivot again using the first column in this split
refer this if needed