Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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.

Anonymous
6 years ago
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]

4 Replies

Anonymous
Not applicable
6 years ago
I am presuming that you are using the if then else within a new column.

If [Coll1] = null then [Coll2] else [Coll1]
- Anonymous
  Not applicable
  6 years ago
  Yes, I am try to add If-Then-Else under new column
- Anonymous
  Not applicable
  6 years ago
  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
    Not applicable
    6 years ago
    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]

Related content