Create a TABLE with separate columns from a single column in another Table

[AgoZ_KH]

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%	w38
15,29%	1,99%	w38
16,56%	0,49%	w39
11,52%	0,38%	w39
17,06%	0,00%	w40
6,15%	99,53%	w40

My goal is from this table create another like this:

w37_AVG1	w37_AVG2	w38_AVG1	w38_AVG2	w39_AVG1	w39_AVG2	w40_AVG1	w40_AVG2
3,37%	84,52%	70,45%	6,13%	16,56%	0,49%	17,06%	0,00%
5,66%	6,49%	15,29%	1,99%	11,52%	0,38%	6,15%	99,53%

I'm tryng some DAX function (i.e. Table command with Filter) but at the moment I'm still in the dark !

Thanks in advance to whom can hel me ...

Ago

[v-xulin-mstf · Accepted solution]

Hi @AgoZ_KH,

Here is the demo, please try it.
Here is the output:

Best Regards,

Link

[AgoZ_KH]

Hi @v-xulin-mstf have a nice day!

really this seem a Columbus egg solution!! It's seem totally meet my requirement!!

Thanks a lot!!

A.

[amitchandak]

@AgoZ_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_KH]

Thanks @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