+ Reply to Thread
Results 1 to 3 of 3

Power query List.Transform to date not working?

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

    Power query List.Transform to date not working?

    I'm trying to use List.transform and date.from, but just have the same list of numbers.

    So having got a list of dates uisng { date.. date } , i have got as far as this ;

    Please Login or Register  to view this content.
    but the list of 'list' of dates all remain as numbers? I can't see where I'm going wrong, I've attached the workbook, table1,

    help,

    Richard.
    Attached Files Attached Files
    Last edited by Dicken; 07-30-2022 at 01:51 PM. Reason: make more clear

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Power query List.Transform to date not working?

    Try

    = Table.AddColumn(#"Changed Type", "Custom", each List.Transform({ Number.From([#"Sart Date "])..Number.From([End Date] ) },Date.From))

    or
    = Table.AddColumn(#"Changed Type", "Custom", each List.Dates([#"Sart Date "],Number.From([End Date]-[#"Sart Date "])+1,Duration.From(1)))
    Attached Files Attached Files

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

    Re: Power query List.Transform to date not working?

    Thanks, I acutually got it working in the end;


    Thanks for your help,
    I acutually got it working, in the end;

    Please Login or Register  to view this content.
    I shall look into Duration.From as it's not a function I was aware of ,

    Thanks,

    Richard.

+ 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 List.Transform syntax
    By Dicken in forum Office 365
    Replies: 2
    Last Post: 06-13-2022, 08:27 AM
  2. [SOLVED] Transform data in Power Query
    By no_Fate in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-19-2022, 06:25 AM
  3. Power query - transform help
    By N3CREN in forum Excel General
    Replies: 0
    Last Post: 10-23-2020, 09:01 AM
  4. Power Query: Combine and Transform from folder
    By LUKE92 in forum Excel General
    Replies: 13
    Last Post: 06-26-2019, 12:34 AM
  5. [SOLVED] Power Query transform help
    By ierosadopr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2019, 05:25 AM
  6. Power Query (Get & Transform) on Mac
    By SHI.NL in forum Excel General
    Replies: 2
    Last Post: 05-18-2018, 09:24 AM
  7. [SOLVED] Power Query / Get & Transform - filter text contains based on list
    By SHI.NL in forum Excel General
    Replies: 8
    Last Post: 05-14-2018, 04:53 PM

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