Date Type Issue while creating a column in Power BI

[Anonymous]

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 !

[Anonymous]

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 · Accepted solution]

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