Forum Discussion

Rubal's avatar
Rubal
Helper II
7 years ago

DAX IF Formula error

Hi,   I am getting the below errors on the If Formula. Can anyone please help on how to resolve it? Thank you.      Vol(Cases / Suom) = if (t_sales_aggregate[Actual or Forecast]="Forecast", (t...
Need Help
Arjunarao's avatar
Arjunarao
Resolver I
7 years ago
Yes.
Specified columns in your expression.
Vol(Cases / Suom) =
IF (
t_sales_aggregate[Actual or Forecast] = "Forecast",
( t_sales_aggregate[Volume (Cases)] && t_sales_aggregate[Volume (SUOM)] )
* AVERAGE ( t_sales_aggregate[Forecast Growth] ),
( t_sales_aggregate[Volume (Cases)] && t_sales_aggregate[Volume (SUOM)] )
)
Rubal's avatar
Rubal
Helper II
7 years ago

Hi Arjun,

 

Please excuse my ignorance. but where is the difference between the codes? seems exactly the same as mine but formatting. appreciate your help.

    • Rubal's avatar
      Rubal
      Helper II
      7 years ago

      Hi Arjun,

       

      Changing the formatting didn't solve the error :(

      • Arjunarao's avatar
        Arjunarao
        Resolver I
        7 years ago
        Yes. But why dont you upload the sample file?