Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Please help me how can i achive over MS Power BI - Query :-
If IsNull (Coll 1)
then Coll2
else Coll1
Thanks in Advance.
Solved! Go to 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]
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]
Yes, I am try to add If-Then-Else under new column
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.