The True/False expression does not specify a column.

[Luis_Caston]

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[AñoFiscal])-1), "#,0,") & " " & "kg total"

When I add this: MAX(Calendario[AñoFiscal])-1 I obtain header error.

I've a column Fiscal Year (as number) and I want to rest -1 to the Fiscal Year selected.

Do you know what I'm doing wrong?

[Anonymous · Accepted solution]

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. 

[Luis_Caston]

Wow @Anonymous that's what I needed!!

Thank you so much!!
That's perfect.

@elitesmitpatelthank you so much too, appreciate!

[Luis_Caston]

Dear all!

I add the pbix: Year -1 

Thank you for your support.

[elitesmitpatel]

Please share the PBIX file with Dummy data and Highlight the expected output.

[elitesmitpatel]

Hey @Luis_Caston 

The issue with your formula is related to how MAX(Calendario[AñoFiscal])-1 is used inside the FORMAT function. The error occurs because MAX(Calendario[AñoFiscal])-1 may not be handled correctly when passed into functions like FORMAT without proper context.

Try this Measure:--

VAR PreviousFiscalYear = MAX(Calendario[AñoFiscal]) - 1

RETURN
FORMAT(
CALCULATE(
[Peso Neto Salidas],
ALL(Cliente[Alias Cliente]),
ALL(LineasSalidas[Alias - Marca]),
PreviousFiscalYear
),
"#,0,"
) & " kg total"

If it helps Kudos the work and Accept it as Solution.

[Luis_Caston]

Hi @elitesmitpatel 

Thank you for your support!
Same error. I've change your approach avoiding the FORMAT but idem, the same error:

VAR PreviousFiscalYear = MAX(Calendario[AñoFiscal]) - 1

RETURN

CALCULATE(

[Peso Neto Salidas],

ALL(Cliente[Alias Cliente]),

ALL(LineasSalidas[Alias - Marca]),

PreviousFiscalYear

)