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. #7
    Member
    Join Date
    Sep 2013
    Posts
    37
    Rep Power
    0
    hi Sandy666,
    i found new problem and to modified like this with the same example before it
    how to way or make formula to sort "name of city (in col C)" with sort list like this below, start from first sort order
    1. KPKNL Padang
    2. KPKNL Bukittinggi
    3. KPKNL Pekanbaru
    4. KPKNL Batam
    5. KPKNL Dumai

    would you help me out?
    Last edited by muhammad susanto; 01-19-2022 at 09:24 AM.

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
  •