Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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