Forum Discussion
How to sum when filter is based on the row
Hi All, I have a fact table that contain: - amount of sales (DC) - Department (product group) - department&year&month (product group & FYM) I want to create a formule similer to excel sum if...
WinterMist
Impactful Individual
Impactful Individual
Hi, maybe im missing here something
at row 8 in your explanation
where:
productgroup&FYM is my original column
Var_group =
max(Invoices[Productgroup& FYM]))
any idea why im getting this error?
thx again