Forum Discussion
Solved
Excel cell as input for parameter
Hi guys, I'm trying to set up a parameter in Power Query based on an Excel named cell called YTD_date. The reason I'm using a parameter is because this one can be used to add a conditional column ...
hey,
you need to convert the query column with the wanted parameter to list, go to tranform tab and select the wanted column as parameter and convert to list.
if this helped please give some kudos and mark as solution for others to find
hey,
you need to convert the query column with the wanted parameter to list, go to tranform tab and select the wanted column as parameter and convert to list.
if this helped please give some kudos and mark as solution for others to find