Forum Discussion

Luis_Caston's avatar
Luis_Caston
Helper III
1 year ago
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[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?
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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. 

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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. 

  • elitesmitpatel's avatar
    elitesmitpatel
    Solution Supplier
    1 year ago

    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's avatar
      Luis_Caston
      Helper III
      1 year ago

      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
      )
  • elitesmitpatel's avatar
    elitesmitpatel
    Solution Supplier
    1 year ago

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