Forum Discussion

ritanoori's avatar
ritanoori
Resolver I
6 years ago
Solved

Value.Is

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...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    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"

     

camargos88's avatar
camargos88
Community Champion
6 years ago

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"

 

  • ritanoori's avatar
    ritanoori
    Resolver I
    6 years ago

    Thank you so so much!!! 🙂