Forum Discussion
List.Average and Select rows
Hello, could someone help me with this problem? I am trying to add this formula =List.Average(Table.SelectRows(#"added custom6", each [roles] = _[roles])[wage]) I have this table ROLES WAG...
Hi Anonymous
#"Nested Join" = Table.NestedJoin(#"Grouped Rows", {"ROLES"}, #"Changed Type", {"ROLES"}, "Table", JoinKind.FullOuter)This step is to merge "Changed Type" and "Grouped Rows", which realizes the merging of the current query itself.
What is your Desktop version?
Best Regards,
Yulia Xu
Thanks,
so I added that formula to Power Bi, it did average, but it is going in turn
row1 is "role1" (in my original file it is 08001"
row2 is 08001
row3 is 08001
but it added to row1 role1, to row2 role2,...
and the formula created average
row1 - 10,5
row2 - 7,5
row3 - 6,5
the tables I sent are just example
| ROLES | WAGE | AVG |
| 08001 | 1000 | 1033,3333 |
| 08002 | 2000 | 2050 |
| 08001 | 900 | 1033,3333 |
| 08003 | 800 | 800 |
08001 | 1200 | 1033,0333 |
08002 | 2100 | 2050 |
and my file has many rows (thousands) and many variants of roles (hundreds)
I am using (i must use) 2.93.1681.0 64-bit (May 2021)