Hi everyone
In Power Querey, I'm trying to find out a way that whenever my Reference Col starts with FX and contain numbers then "Internal" Example: FX12345 else if it starts with FX and contain text then "External" Example: FXMYRJUNE . I know that type number is not correct so what should I replace it with?
if Value.Is([Reference],type number) and
Text.StartsWith([Reference], "FX") then
"Internal FX Deal"
else
if Value.Is([Reference],type text) and
Text.StartsWith([Reference], "FX") then "External FX Deal"
Thanks
Hi @ritanoori ,
Try this custom column:
if Value.Is(Value.FromText(Text.AfterDelimiter([Column1], "FX")), type number) = true then "Internal FX Deal"
else "External DX Deal"
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Hi @ritanoori ,
Try this custom column:
if Value.Is(Value.FromText(Text.AfterDelimiter([Column1], "FX")), type number) = true then "Internal FX Deal"
else "External DX Deal"
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Helpful resources
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
