+ Reply to Thread
Results 1 to 2 of 2

Power Query Concatenate list of dates

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    776

    Power Query Concatenate list of dates

    Hello,

    Can anyone help me in how to concatenate a list of dates, I've tried various options my latest failure is with ; List.Accumulate;

    I was hoping that as ; source
    Please Login or Register  to view this content.

    Please Login or Register  to view this content.

    gave me a , b , c , I could use it to join a list of dates, but i get the error

    Please Login or Register  to view this content.
    As the ampersand is used when creating an accumulative total using Listaccumulate, eg

    a & {List.Last(a) + b }

    I wondered if anyone might have some suggestions? Work book included showing concatenated text and failure to work with numbers.

    Richard
    Attached Files Attached Files
    Last edited by Dicken; 05-29-2022 at 12:40 PM. Reason: Moderator request

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,759

    Re: Concatenate list of dates

    A workbook will always help, if only to eliminate possible issues. I presume this is to do with PowerQuery? Your thread title needs to be a bit more specific, please.
    Last edited by AliGW; 05-29-2022 at 11:52 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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    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] Concatenate long list with punctuation (email list)
    By cathyrd in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-14-2022, 11:45 AM
  2. [SOLVED] Concatenate list of dates in power query
    By Dicken in forum Office 365
    Replies: 6
    Last Post: 06-09-2022, 10:43 AM
  3. Validation list (dependent on the result of the preceding list) + Concatenate
    By Elainefish in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-08-2013, 09:19 AM
  4. [SOLVED] Concatenate list of dates into one cell without duplicates
    By rachel.dudley in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-14-2013, 07:38 AM
  5. Replies: 2
    Last Post: 04-12-2010, 12:35 PM
  6. CONCATENATE w/Dates
    By ExcelJunkie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2008, 07:07 PM
  7. concatenate dates
    By JNEAL82 in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 10-03-2007, 11:17 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