Forum Discussion
New Table to Create Categorize Existing Columns
Hello sirs.. I might not have described title clearly.. what I want to do is converting following data; Date Unit1 Unit2 Unit3 01.01.2020 100 200 300 02.01.2020 150 300 250 ...
Anonymous , Unpivot and then either split or replace Unit with empty string
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/https://docs.microsoft.com/en-us/powerquery-m/text-replace
Or right click on the new column and use replace unit with empty
amitchandak
Super User
Super UserAnonymous , Unpivot and then either split or replace Unit with empty string
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
https://docs.microsoft.com/en-us/powerquery-m/text-replace
Or right click on the new column and use replace unit with empty