Forum Discussion
AgoZ_KH
Resolver I
Resolver ICreate a TABLE with separate columns from a single column in another Table
Hi All Community! I'm try to create aDAX formula to achive this result. Suppose you have a table like this: AVG 1 AVG2 week 3,37% 84,52% w37 5,66% 6,49% w37 70,45% 6,13% ...
amitchandak
Super User
Super UserAgoZ_KH , Seem like one column is missing, because not sure how your second row.
Unpivot or transpose
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
In matrix - Show on row option with selected Col /rows
AgoZ_KHResolver I
Resolver IThanks amitchandak
excuse my late answer! It's a good suggestion, but in my scenario the problem is pivot in the same time two columns and this seem not to achieve my principal goal.
Ago