Modify Table to show every year as separate column

[rsamoth]

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!

[Larsfin · Accepted 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