Excel cell as input for parameter

[Tom83]

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 to my dataset. This is what I've done up so far:

Added the cell to PowerQuery:

let
Source = Excel.CurrentWorkbook(){[Name="YTD_date"]}[Content],
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"31-12-2021", type date}})
in
#"Changed Type"

Now I want to setup the Parameter but it doens't allow me to select the query, any idea why? When creating a new query it's shown but not giving the excel balue. Is this the right way or would there be an easier solution to fix this? I just want to use an input cell to use in a conditional column to calculate the amounts YTD on record level, I don't want to filter rows based on this cell-value because I need the other rows as well.

[StefanoGrimaldi · Accepted solution]

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