Results 1 to 10 of 10

Thread: Power Query Formula to Make Column Keep Retain Alphabetic When Refresh

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    Sep 2013
    Posts
    37
    Rep Power
    0

    Power Query Formula to Make Column Keep Retain Alphabetic When Refresh

    hi all..

    i have appended file when new refreshing data the column and rows is change
    how to make formula in PQ so that in column C "KPKNL" automatic keep alphabetic sort.
    here my attachment picture
    any one help me, greatly appreciated

    .susanto
    Attached Images Attached Images

Similar Threads

  1. PQ - Power Query split?
    By sandy666 in forum Power Query, Power Pivot and Power BI
    Replies: 1
    Last Post: 04-06-2021, 07:51 PM
  2. PQ - Power Query: search multiple columns against a list of values?
    By sandy666 in forum Power Query, Power Pivot and Power BI
    Replies: 0
    Last Post: 02-22-2021, 11:50 PM
  3. PQ - Transforming Text to Date in Power Query
    By sandy666 in forum Power Query, Power Pivot and Power BI
    Replies: 2
    Last Post: 02-22-2021, 01:08 AM
  4. PQ - How to get Total via Power Query
    By sandy666 in forum ETL PQ Tips and Tricks
    Replies: 0
    Last Post: 09-23-2020, 06:10 PM
  5. PQ - UnZip an use Content in Power Query
    By sandy666 in forum ETL PQ Tips and Tricks
    Replies: 0
    Last Post: 05-13-2020, 05:37 AM

Posting Permissions

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