Average Line

[Anonymous]

Hey,

I Try to add an calculated column. the new column will calcualte average number for all the parametes that include the letter "A", for example: In team Sarah the numbers that will be calculated are: 5 + 10 + 10 because they are the only numbers that under parameter that containing the letter "A", and the average will be 8.33.

Thanks for helping!

[Anonymous · Accepted solution]

Hi @Anonymous,

Nope, current dax formula not support loop column name, I'd like to suggest you enter to query editor and use unpivot columns to transform your table.

Reference link:

Unpivot Data Using Excel Power Query

Then you can write formula based on attribute and value columns.

Regards,

Xiaoxin Sheng

[Anonymous]

Anyone? Please?