Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Guys,
I´ve this BI Table. In The column "Time.Years" I´ve the years 2016 - 2019.
Instead of having one column with all years i would like to have seperate columns for every year.
Like in this excel the amount should be shown in the right year column.
I´m sure that can be handled with Power Bi
Thanks for your help!
Solved! Go to Solution.
You can do this in Power Query.
Go to Edit Queries and in the transform section select the column and choose "pivot column".
Best,
Lars
You can do this in Power Query.
Go to Edit Queries and in the transform section select the column and choose "pivot column".
Best,
Lars
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |