Forum Discussion

abehrmann's avatar
abehrmann
Icon for Helper II rankHelper II
8 years ago

Creating a new table in Power BI using aggregated data from other tables

I have a data set looking at workorders my company completes,  there are workorder #s and users assiged to them.    i am looking to create a new table that agregates varous metrics from the data se...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

abehrmann you need to use allexcept to avg it at a users level

 

CALCULATE(AVG(table1[worktime], allexcept(table1, table1[user]))

 

https://msdn.microsoft.com/en-us/query-bi/dax/allexcept-function-dax

 

once you have all the metrics, if you want to create an agg table with them you can use calculated tables. I think you can create using distinct and values function. chck details in the next link(https://docs.microsoft.com/en-us/power-bi/desktop-calculated-tables).