Could somebody tell me the correct syntax for Text.End where I want to specify the text in the column.
I was trying to replace this:
With this:
But it didn't work.
Many thanks
I was trying to replace this:
Code:
= Table.AddColumn(#"Added Cleaned Class Col", "Year", each if Text.EndsWith([Year SIMS], "N1") then "Year R" else if Text.EndsWith([Year SIMS], "N2") then "Year R" else [Year SIMS] )
With this:
Code:
#"Added Conditional Column" = Table.AddColumn(#"Added Cleaned Class Col", "Year", each if Text.End([Year SIMS], "N",2) then "Year R"),
But it didn't work.
Many thanks