Forum Discussion

BiscuitKen's avatar
BiscuitKen
Frequent Visitor
2 years ago
Solved

Conditionally Update Columns in Pivoted Data

Hi   I've pivoted data and now want to update the values that are null to STANDARD but only where 'WorkType' = SHIFT regardless of the dates in the column headers as these will change.   The data...
Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi BiscuitKen 

     

     

    = Table.ReplaceValue(#"Pivoted Column",null, each if [WorkType]="SHIFT" then "STANDARD" else null,Replacer.ReplaceValue,Table.ColumnNames(#"Pivoted Column"))

     Stéphane

slorin's avatar
slorin
Super User
2 years ago

Hi BiscuitKen 

 

 

= Table.ReplaceValue(#"Pivoted Column",null, each if [WorkType]="SHIFT" then "STANDARD" else null,Replacer.ReplaceValue,Table.ColumnNames(#"Pivoted Column"))

 Stéphane