Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
)