Adding a new column in PowerBI

Column name is case-sensitive and If any rows have null in Case_Title, Text.Contains will throw an error. Try this instead:

Table.AddColumn(
    #"Changed Type",
    "Case_Category",
    each
        if [Case_Title] <> null
           and Text.Contains([Case_Title], "Voucher", Comparer.OrdinalIgnoreCase)
        then "Voucher Issue"
        else "Other"
)

---

Hallo,

 

die Anweisung ist nicht zu beanstanden. Wie lautet denn die Fehlermeldung?

Thanks, I tried that, but it's still returning the word Error in the results of the column.

Hi afaber ,

Thank you for reaching out to the Microsoft Community Forum.

If your column contain errors, nulls  or unexpected values, Please try below M code to fix the issue.

Table.AddColumn(
#"Changed Type",
"Case_Category",
each
try
if Text.Contains(
Text.From([Case_Title]),
"voucher",
Comparer.OrdinalIgnoreCase
)
then "Voucher Issue"
else "Other"
otherwise "Other",
type text
)

Below M code handles nulls and case variations.

= Table.AddColumn(
#"Changed Type",
"Case_Category",
each
if [Case_title] <> null
and Text.Contains([Case_title], "voucher", Comparer.OrdinalIgnoreCase)
then "Voucher Issue"
else "Other",
type text
)

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

Hello afaber , Please find the below solution 
Before:

After