Problem input: I have 3 columns:
Column 1: Week start date (variable)
Column 2: SKU (variable)
Column 3: SPA Sales (variable)
Question: how do I sum up “SPA Sales” for every “SKU” in a specific “Week start date” to get a total of “SPA Sales” for every “Product” in every “Week Start Date”. Note: values in "SKU" contain duplicate values for the same "Week start date"
Expected outcome description:
In the attached file - column "Raw2-SPA", you will need to sum up the values from the column "SPA Sales" for every SKU in every "Week Start" date range so the output will be:
Week Start: X1
Week Start: X2
and so on for all the SKUs and all the Weeks
Attempted Solution: =SUMMARIZE(BR,'BR'[Week Start],'BR'[SKU],"Total Sales Test", SUM(BR[Total Sales])))
Error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
From what I understood, the output should be a calculated table because I need totals based on 3 varying conditions/criteria, but I cannot implement it in Powerpivot DAX.