Turning columns to rows or rows to columns is easy with Power Query and Power BI. There are many situations that you get a name, value data source, and wants to convert that into columns with values underneath. On the other hand, many times you get multiple columns and want to change it to name, value structure with a column for name, another column for value. That’s why Pivot and Unpivot are for. In this video, you will learn how to use Unpivot to transform the budget data to a much better dataset to use for analytics.
the details of the example are in my article here:
0 Comments