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

Hi,

To change the data type of a column from source is :

Go to Edit Query

Select the column

Go to Transform tool bar > Data Type and change 

 

Rubal's avatar
Rubal
Helper II
7 years ago

Hi Arjun,

 

I don't even see the column into the query editor? Is this because it is a column measure?

  • 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.