If - Then - Else Statement

[Anonymous]

Hello,

Please help me how can i achive over MS Power BI - Query :-

If IsNull (Coll 1) 

then Coll2 

else Coll1

Thanks in Advance.

[Anonymous]

I am presuming that you are using the if then else within a new column.

If [Coll1] = null then [Coll2]  else [Coll1]

[Anonymous]

Hello,

I have tried following fuction but it didn't worked, please suggest 

if Text.Trim([CI ID]) = NULL
then [Server Name]
else [CI ID]

[Anonymous · Accepted solution]

Power query is case sensitive. Also, trim will not turn a bunch of spaces into null. Are you testing for null, blank spaces or both?

Below is both

if [CI ID] = null  or Text.Trim([CL ID]) = "" then  [Server Name] else [CI ID]

[Anonymous]

Yes, I am try to add If-Then-Else under new column