Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date Type Issue while creating a column in Power BI

Hi All,

I am new to power BI.

 

I am trying to create a Simple IF statement logic below:
(IF [R_NO] = 1 THEN [Ageing (Delivery)] ELSE 0 END)

 

where R_NO column is of Whole Number type which has values from 1 to 70 and Delivery column also has values from 1 to 200 etc. 
why am i getting error as both the columns which I am referring are whole number data type.

Please help !

 

 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    HI, Anonymous 

    If your problem has been solved, you could accept the your answer as solution to close this thread.

    Other community members will easily find the solution when they get the same issue.

    Best Regards,
    Community Support Team _ Eason

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi All,

    I got the solution.

    I should not use"1" as it is considering as text . I suppose to use R_NO=1

    I tried and it worked. 

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      3 years ago

      HI, Anonymous 

      If your problem has been solved, you could accept the your answer as solution to close this thread.

      Other community members will easily find the solution when they get the same issue.

      Best Regards,
      Community Support Team _ Eason