Cyclic reference error invoke custom function using parameters

[Anonymous]

Hi, 

I am having an cyclic reference error when I am trying to invoke a custom function useing parameters:

let
Source = Excel.Workbook(File.Contents("C:\Users\ldeoliv\OneDrive - Rockwell Automation, Inc\DATES.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
WHStarts = Number.From(WHStart),
WHEnds = Number.From(WHEnd),
#"Promoted Headers" = Table.PromoteHeaders(#"Sheet1_Sheet",[PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"DATE_COMPLETE", type datetime}, {"DATE_INPROCESS", type datetime}}),
#"Invoked Custom Function" = Table.AddColumn(#"Changed Type", "fWH", each fWH(WHStarts, WHEnds, [DATE_INPROCESS], [DATE_COMPLETE], Holidays))
in
#"Invoked Custom Function"

Someone could help me?

Thanks

[Anonymous]

HI @Anonymous ,

I'm not so clear for your custom functions, can you please share more about this?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng