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.
I'm getting this error, what am i missing.
summary
i want to create a colum that looks at 1 column for text.contains "XXXXX" and the start of another column doesn't start with text "YYYYY_______" then return a result
Solved! Go to Solution.
Table.AddColumn(
your_table,
"LHRR",
each
if Text.Contains([a], "xxxx") and
not Text.StartsWith([b], "yyyy")
then "LHRR"
else "notLHRR"
)
ledgend. thanks so much
Table.AddColumn(
your_table,
"LHRR",
each
if Text.Contains([a], "xxxx") and
not Text.StartsWith([b], "yyyy")
then "LHRR"
else "notLHRR"
)
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.