Forum Discussion
GokilaRaviraj
Helper II
Helper IICopy and paste entire colum value to another column
Hi , Currently my table data looks like below Since we are in October, It shows months from Oct to Next year Dec. From Next month It shows months from Nov to Next year dec. This input value colu...
May be
= if List.Contains(Table.ColumnNames(#"Replaced Value"),"Mar-CFY")
then Table.ReplaceValue(#"Replaced Value", each [#"Mar-CFY"], each [Value], Replacer.ReplaceValue, {"Mar-CFY"})
else #"Replaced Value"Stéphane
slorin
Super User
Super UserMay be
= if List.Contains(Table.ColumnNames(#"Replaced Value"),"Mar-CFY")
then Table.ReplaceValue(#"Replaced Value", each [#"Mar-CFY"], each [Value], Replacer.ReplaceValue, {"Mar-CFY"})
else #"Replaced Value"
Stéphane
GokilaRaviraj