Forum Discussion

brinky's avatar
brinky
Icon for Helper IV rankHelper IV
3 years ago
Solved

power query replace

Could some one assit what I'm doing wrong, I'm trying to combine "Route" with [Route_No] and is reaming blamk whereas when I add [Epiry_date] is works perfectly.   Thanks in advance  
Need Help
  • m_dekorte's avatar
    m_dekorte
    3 years ago

    You're missing the parenthesis

     

    Table.ReplaceValue(#"Filtered Rows", each [Route_Description], each if [Route_No] = 125 then "Route" & Text.From([Route_No]) else [Route_Description], Replacer.ReplaceValue,{"Route_Description"})

brinky's avatar
brinky
Icon for Helper IV rankHelper IV
3 years ago

Still nothing

 

= Table.ReplaceValue(#"Filtered Rows", each [Route_Description], each if [Route_No] = 125 then "Route" & Text.From[Route_No] else [Route_Description], Replacer.ReplaceValue,{"Route_Description"})

m_dekorte's avatar
m_dekorte
Icon for Resident Rockstar rankResident Rockstar
3 years ago

You're missing the parenthesis

 

Table.ReplaceValue(#"Filtered Rows", each [Route_Description], each if [Route_No] = 125 then "Route" & Text.From([Route_No]) else [Route_Description], Replacer.ReplaceValue,{"Route_Description"})

  • brinky's avatar
    brinky
    Icon for Helper IV rankHelper IV
    3 years ago

    Gosh, spot on m_dekorte thanks for your help, much appricated.