Forum Discussion

Rubal's avatar
Rubal
Icon for Helper II rankHelper 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
adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
7 years ago

Hi Rubal 

 

change the data type from Text to Wole Number.

The calculation columns you are doing in this formula.

 

 

 

  • Rubal's avatar
    Rubal
    Icon for Helper II rankHelper II
    7 years ago

    Hi Aditya,

     

    Thanks for your comments. As I am new to Power BI I am not sure how to do it. As it is a calculated column I do not see it in the query editor. How and where can I change the data type? Your help is highly appreciated.

     

    Thanks.

    • tarunsingla's avatar
      tarunsingla
      Icon for Solution Sage rankSolution Sage
      7 years ago

      The error message indicates that the data type of the calculation for if true section is different than the data type for the if false section. Ensure that in an IF statement, the data type of the resulting expression is same for all cases.