Forum Discussion
Solved
Issue Treating nulls in Conditional Column of Type Any
Hi All, I have a column Name of which I am extracting only rows that contain words like "Additive" using conditional column , I have attached the M-Query code for the same. The issue I am facing ...
if Text.Contains(Text.From([Name]??""),"Additive") then [Name] else null
if Text.Contains(Text.From([Name]??""),"Additive") then [Name] else null