Results 1 to 5 of 5

Thread: Error: We Cannot Convert a value of Type Function to Type list
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2015
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Error: We Cannot Convert a value of Type Function to Type list

    I have been trying to create a function to calculate the number of working days (including holidays). I found instructions on how to create fnNetworkdays but I am getting the following error when I try to use it in a query:

    Expression.Error: We cannot convert a value of type Function to type List.
    Details:
    Value=Function
    Type=Type

    I have no clue what it means. Here is my M coding for the function:

    (StartDate as date, EndDate as date) as number =>
    let
    Source = List.Dates,
    #"Invoked Function Source" =
    if StartDate <= EndDate then
    Source(StartDate,Duration.Days(EndDate-StartDate)+1, Duration.From(1))
    else
    Source(EndDate, Duration.Days(StartDate-EndDate)+1, Duration.From(1)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Inserted Day of Week" = Table.AddColumn(#"Converted to Table", "Day of Week", each Date.DayOfWeek([Column1],Day.Monday), Int64.Type),
    #"Filtered Rows" = Table.SelectRows(#"Inserted Day of Week", each ([Day of Week] <> 5 and [Day of Week] <> 6)),
    Custom1 = if StartDate <= EndDate then Table.RowCount(#"Filtered Rows") else Table.RowCount(#"Filtered Rows")*(-1)
    in
    Custom1

    Can anyone see where I am going wrong? This is the instructions I followed: https://www.powerquery.training/networkdays/

  2. #2
    Board Regular
    Join Date
    Apr 2014
    Posts
    80
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error: We Cannot Convert a value of Type Function to Type list

    I've had this problem before and it was because you were using a table instead of a list.
    Click on the query column heading and select drill down.

  3. #3
    Board Regular
    Join Date
    Sep 2015
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error: We Cannot Convert a value of Type Function to Type list

    I need the information to stay in table format unfortunately

  4. #4
    Board Regular
    Join Date
    Nov 2016
    Posts
    109
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error: We Cannot Convert a value of Type Function to Type list

    Shouldn't the line

    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

    Actually be:
    #"Converted to Table" = Table.FromList(#"Invoked Function Source", Splitter.SplitByNothing(), null, null, ExtraValues.Error),

  5. #5
    Board Regular
    Join Date
    Sep 2015
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error: We Cannot Convert a value of Type Function to Type list

    I will give it a try!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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