Forum Discussion

han_rj's avatar
han_rj
Helper IV
1 year ago
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 ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    1 year ago

    if Text.Contains(Text.From([Name]??""),"Additive") then [Name] else null

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi han_rj,


Thanks Akash_Varuna  and wdx223_Daniel  for Addressing the issue.

 

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

Regards,
Vinay Pabbu