Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Alicia_Anderson
Resolver I
Resolver I

Conditional Column based on Text.Contains gives sporadic error

I have 2 columns defined as Text (Reported in Release & Support Version).   I replaced all nulls in each column.   I have logic to use either the value from the first column or the 2nd column field to create the new column (Rep Release/Version).   This part works fine.   

Next I want to create another conditional column based on the results of the new column.   First I added a step to ensure the new column (Rep Release/Version) was defined as Text.  I am using Text.Contains logic to determine value for new field.   

 

I am getting the error "We cannot convert the value null to type Logical" for only a percentage of values.  This makes no sense because there is no null value.  Please help.  

 

Alicia_Anderson_0-1636416295445.png

Alicia_Anderson_1-1636416354511.png

 

1 ACCEPTED SOLUTION
Alicia_Anderson
Resolver I
Resolver I

I finally figured out the problem.  There was an additional field that I used in the conditional column (which was not included in my screenshot).   That field still had some null values.   

View solution in original post

3 REPLIES 3
Alicia_Anderson
Resolver I
Resolver I

I finally figured out the problem.  There was an additional field that I used in the conditional column (which was not included in my screenshot).   That field still had some null values.   

Hi @Alicia_Anderson ,


Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.


Best Regards,
Stephen Tao

PhilipTreacy
Super User
Super User

Hi @Alicia_Anderson 

 

It's hard to debug this without the source data and your query code - can you supply them?

 

You say First I added a step to ensure the new column (Rep Release/Version) was defined as Text - is this working for all rows?  How did you implement this?

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors