Forum Discussion
Solved
Create a new table that categorizes values in a column based on columns and rows in another table
Hi everyone, thank you in advance for the help, this community has been great with input and fast replies. What I'm trying to do is create a new table that takes values from a few columns (and ro...
Try this
SummaryTable =
SUMMARIZE(
ProductionOrders,
ProductionOrders[Production Order],
ProductionOrders[Revenue Category],
"Budget Category Revenue", MAX(ProductionOrders[Budget Category Revenue per SKU]),
"Total Actual Category Revenue", SUM(ProductionOrders[SKU ASP])
)
nilendraFabric
Super User
Super UserTry this
SummaryTable =
SUMMARIZE(
ProductionOrders,
ProductionOrders[Production Order],
ProductionOrders[Revenue Category],
"Budget Category Revenue", MAX(ProductionOrders[Budget Category Revenue per SKU]),
"Total Actual Category Revenue", SUM(ProductionOrders[SKU ASP])
)
Thanks very much for the quick reply niledra. That did it!