Hi All Community! I'm try to create aDAX formula to achive this result. Suppose you have a table like this:AVG 1AVG2week3,37%84,52%w375,66%6,49%w3770,45%6,13%w3815,29%1,99%w3816,56%0,49%w3911,52%0,38%w3917,06%0,00%w406,15%99,53%w40 My goal is from this table create another like this:w37_AVG1w37_AVG2w38_AVG1w38_AVG2w39_AVG1w39_AVG2w40_AVG1w40_AVG23,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

Hi AgoZ_KH, Here is the demo, please try it.Here is the output: Best Regards,Link

Forum Discussion

Resolver I

5 years ago

Solved

Hi All Community!

I'm try to create aDAX formula to achive this result.

Suppose you have a table like this:

My goal is from this table create another like this:

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