Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
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
Anyone? Please?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |