+ Reply to Thread
Results 1 to 4 of 4

Power queries - formulas do not work

  1. #1
    Registered User
    Join Date
    02-23-2022
    Location
    Warszawa
    MS-Off Ver
    16
    Posts
    15

    Power queries - formulas do not work

    Hello,

    In excel sheet I have some columns with formulas, now I need to create in Power Queries the same columns with the same formulas, but it does not work...
    Does formulas in PQ have different construction? Is there any tool that can convert them to me?

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Power queries - formulas do not work

    Quote Originally Posted by excelowy_amator View Post
    Does formulas in PQ have different construction?
    Yes, it's a completely different language

    Is there any tool that can convert them to me?
    Not that I know of. I suggest you post the workbook and explain what you need converted.
    Rory

  3. #3
    Registered User
    Join Date
    02-23-2022
    Location
    Warszawa
    MS-Off Ver
    16
    Posts
    15

    Re: Power queries - formulas do not work

    In excel I have a column D- Categories, and column I - Process
    Now, I want to pull out only the process, so for example: "Material Creation"
    I have a formula in excel but I do not know formula in PQ


    Attachment 770831

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,366

    Re: Power queries - formulas do not work

    You need to use either the SPLIT or the EXTRACT option on the TRANSFORM tab in PowerQuery.

    Based on your recent PQ queries here, I suggest you spend a day just playing with each of the menu items in the PQ editor to see what they do. You can achieve an awful lot without writing custom code.
    Last edited by AliGW; 03-03-2022 at 04:42 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. [SOLVED] Trying to delete all power queries in workbook
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2021, 12:10 AM
  2. Power query - Detect Queries That Did Not Run Sucessfully
    By AllisterB in forum Excel General
    Replies: 0
    Last Post: 05-03-2021, 05:40 AM
  3. Replies: 2
    Last Post: 01-21-2020, 04:28 AM
  4. 2016 Power Queries do not refresh in Excel 365 Pro Plus
    By Ruby55 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2020, 10:19 PM
  5. Power Query - How to refresh queries?
    By ypurcaro in forum Excel General
    Replies: 11
    Last Post: 02-11-2019, 06:47 PM
  6. Editing Workbook Queries (Power Query)
    By dizjackson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2019, 03:11 AM
  7. Help with multiple URLs and auto Power Queries
    By joffy1979 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2015, 04:28 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