Forum Discussion
Referencing external tables column in function
Hi all, Hope you can help me with this. My basic question is, how can I reference an external table from within a function from within the PowerQuery editor. Here's my setup: I have a table w...
Hello ImkeF,
Sorry I was not clear earlier.
What I am doing is joining all entries from the table "HOLIDAYS" to each entry from the table "TASKS". Result of this process is a list that is located in a separate column, called "HolidayList", that I am then checking against Start- and end date.
The code for this step in Power Query is:
=Table.AddColumn(#"LastStep", "Holidays", each HOLIDAYS[Date])Afterwards, I am passing this table to the function that I described earlier calculating the elapsed time as parameter "HolidayList".
Hi Anonymous ,
are you able to share a sample workbook with some mockup data please?