Forum Discussion
Solved
The True/False expression does not specify a column.
Dear all, I've a problem with this formula and I don´t know why. Formula: FORMAT(CALCULATE([Peso Neto Salidas], ALL(Cliente[Alias Cliente]), ALL(LineasSalidas[Alias - Marca]), MAX(Calendario[...
Hi Luis_Caston ,
Thanks elitesmitpatel for the quick reply. I have some other thoughts to add:
Peso Neto Salidas Año Fiscal -1 = var _a= CALCULATE([Peso Neto Salidas], FILTER(ALL('Calendario'),[AñoFiscal]=SELECTEDVALUE('Calendario'[AñoFiscal])-1)) RETURN FORMAT(_a,"#,0,") & " kg total"Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Luis_Caston ,
Thanks elitesmitpatel for the quick reply. I have some other thoughts to add:
Peso Neto Salidas Año Fiscal -1 =
var _a= CALCULATE([Peso Neto Salidas], FILTER(ALL('Calendario'),[AñoFiscal]=SELECTEDVALUE('Calendario'[AñoFiscal])-1))
RETURN FORMAT(_a,"#,0,") & " kg total"
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Wow Anonymous that's what I needed!!
Thank you so much!!
That's perfect.
elitesmitpatelthank you so much too, appreciate!
