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 Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
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.
