Forum Discussion
If - Then - Else Statement
Hello, Please help me how can i achive over MS Power BI - Query :- If IsNull (Coll 1) then Coll2 else Coll1 Thanks in Advance.
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]
I am presuming that you are using the if then else within a new column.
If [Coll1] = null then [Coll2] else [Coll1]
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]
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]