Forum Discussion
Nested IF statement in custom column
Dear All, I'm trying to create a custom column as follows: var SUPPLIERS = CALCULATE(SUM(Cashflow[Importo (+/-)]),Cashflow[Source]=0,VALUES(Cashflow[Categoria])="FORNITORI") var PREVISIONE_...
This pattern is likely the issue. I see it in two places. Also, are you sure you want to create a column for this? Which table are you putting it on? A measure may be better.
VALUES ( Cashflow[Categoria] ) = "FORNITORI"
Try just
Cashflow[Categoria] = "FORNITORI"
Pat