Forum Discussion
rlebeau
2 years agoNew Member
Summarize Table combined with dynamic columns
Hi, I have a formula that looks like this and it works perfectly: COGS Delta Volume = SUMX(SUMMARIZE(sales,Entity[Legal Entity],TB_Products[Product Category] ) ,([Quantity] - [Qty LY])*...
rlebeau
2 years agoNew Member
Hi,
First thanks for taking the time to help me. But in your example (if i understand well) you hardcode the product category and product name. I don't know which column the end user is going to select, neither how many.