Forum Discussion
Conditionally Populating Values in Multiple Columns with Variable Headers
One of the first things you will learn when working with Power BI that you need to bring your data into usable format. The term is "unpivoting.
From
To
Then you do some cleanup and type casting
And then you can compute the value
There is no need to re-pivot the data here, this can be done for free in the matrix visual.
One of the first things you will learn when working with Power BI that you need to bring your data into usable format. The term is "unpivoting.
From
To
Then you do some cleanup and type casting
And then you can compute the value
There is no need to re-pivot the data here, this can be done for free in the matrix visual.
Brilliant! It took a little extra fiddling to get the right columns to unpivot but this worked flawlessly. Thank you so, so much for your assistance. I've figured out a decent amount with Power Query but I know I'm missing a good bit of core knowledge so this was a real struggle. I appreciate you!