+ Reply to Thread
Results 1 to 4 of 4

Power Query M formula language or Formula in Power Query

  1. #1
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Power Query M formula language or Formula in Power Query

    Dear All Master ,

    Please help me so that I do not use excel formulas such as in columns C, D, E, F that I marked yellow and I have a custom column in the power query namely PQ-ITEM NO NEW, PQ-GROUP SUPPLIER FIX, PQ-YEAR, PQ -DESCRIPTION so I want the results to use the power query formula or M language so that the results are the same as columns C, D, E, F I have yellow marking.
    The reason I did not use the excel formula is because the record is 200000 lines so when it is refreshed it makes the formula calculation so that it makes it very long. For sheet master items do not need to be unpivoted so that they make many rows.
    Please give me the solution.

    Thanks You

    Kana
    Attached Files Attached Files

  2. #2
    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,336

    Re: Power Query M formula language or Formula in Power Query

    Your profile says Excel 2007 - please update this, as you are using PQ so much have a newer version.
    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.

  3. #3
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Re: Power Query M formula language or Formula in Power Query

    Please help me to solve my problem

  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,336

    Re: Power Query M formula language or Formula in Power Query

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

+ 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] Power Query - excel formula translation into Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-19-2020, 03:38 AM
  2. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  3. Power Query M language- Conditional Lookup/Merge
    By Ballet4ever in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2019, 04:39 PM
  4. 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
  5. write SQLs in power query M language
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-14-2018, 10:56 AM
  6. [SOLVED] formula on power query (M language)
    By pccamara in forum Access Tables & Databases
    Replies: 3
    Last Post: 06-11-2018, 05:16 AM
  7. Replies: 0
    Last Post: 04-05-2018, 01:16 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