+ Reply to Thread
Results 1 to 11 of 11

Power Query - update particular columns

Hybrid View

afgi Power Query - update... 02-13-2020, 05:58 PM
Olly Re: Power Query - update... 02-14-2020, 03:15 AM
afgi Re: Power Query - update... 02-14-2020, 06:51 AM
Olly Re: Power Query - update... 02-14-2020, 09:20 AM
afgi Re: Power Query - update... 02-14-2020, 09:54 AM
Olly Re: Power Query - update... 02-14-2020, 10:26 AM
afgi Re: Power Query - update... 02-14-2020, 10:31 AM
afgi Re: Power Query - update... 02-15-2020, 06:55 PM
Olly Re: Power Query - update... 02-14-2020, 10:44 AM
CK76 Re: Power Query - update... 02-14-2020, 10:57 AM
Olly Re: Power Query - update... 02-16-2020, 06:41 PM
  1. #1
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Power Query - update particular columns

                #"Replace 0" = Text.Replace(GaugeInput,"0",""),
                #"Replace ." = Text.Replace(#"Replace 0",".",""),
                #"Replace MM" = Text.Replace(#"Replace ."," MM",""),
                #"Replace Second Choice" = Text.Replace(#"Replace MM","SECOND CHOICE","")
    I like to combine multiple replace with null/blank with Splitter.SplitByAnyDelimiter()
    Ex:
    Text.Combine(Splitter.SplitTextByAnyDelimiter({"0","."," ","MM","SECOND CHOICE"})(GaugeInput))
    Edit: Woops, forgot closing parenthesis.
    Last edited by CK76; 02-14-2020 at 11:05 AM.
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Select sheet after Power Query Update
    By jonrack in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-05-2019, 02:16 PM
  2. Custom Permutations Column in Power Query from two columns in the same Query
    By PaintPaddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2019, 02:48 PM
  3. [SOLVED] Power Query ranking multiple columns
    By rs1aj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2019, 11:43 PM
  4. Update pivot tables without refreshing power query
    By Acceptablerisk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-25-2019, 04:48 AM
  5. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  6. Power Query Won't Update
    By Justair07 in forum Excel General
    Replies: 9
    Last Post: 09-29-2016, 04:46 PM
  7. automate power query update from new tab (office excel 2016)
    By ajnuna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2016, 07:27 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1