Consulting

Results 1 to 2 of 2

Thread: Sleeper: Power Query - Replace multiple values

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jan 2017
    Location
    Warsaw
    Posts
    70
    Location

    Sleeper: Power Query - Replace multiple values

    Good day!


    How can I replace multiple values with a value in PowerQuery (advanced editor) at once?
    So X = 1, Y = 1, A = 1 etc.


    The actual function looks like this:
    = Table.ReplaceValue (# "Changed Type", "X", "1", Replacer.ReplaceText, {"Value"})

    Best regards!
    Last edited by Aussiebear; 04-24-2023 at 08:47 PM. Reason: Added code tags

  2. #2
    VBAX Regular
    Joined
    Jun 2008
    Posts
    72
    Location
    What if you add a new helper column and use and IF statment?


    #"Added Conditional Column" = Table.AddColumn(PreviousStep, "Custom", each if [Column6] <> null then 1 else null)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •