Excel Power query

[swarnalvr]

Excel Power Query : First tab contain drop of dates for ex.. MonthEnd

Any date is selected in the first tab filters the data in secon tab file ex FSBV

Below logic retrieves first row, 

let
monthEnd = Excel.CurrentWorkbook(){[Name="MonthEnd"]}[Content]{0}[MonthEnd],
#"Converted to List" = {monthEnd}
in
#"Converted to List

but i need the selected row date?

Any help

[Anonymous]

Hi @swarnalvr ,

Thanks for reaching out to our community.

Could you please tell us if your problem has been solved?

If so, please accept the reply as solution and more people will benefit from it.

Thanks.

Best Regards,

Stephen Tao

[PwerQueryKees]

Change the 9 in [Content]{9} to the name of your parameters like [Content]{#"The parameter giving the number of the desired month end"}

[swarnalvr]

thanks but i have approached parameters concept

[Omid_Motamedise]

Use this formula for year 2023


= List.Transform({1..12}, each Date.EndOfMonth(#date(2023,_,1)))

[swarnalvr]

monthEnd = Excel.CurrentWorkbook(){[Name="MonthEnd"]}[Content]{9}[MonthEnd],

for example above query pulls the 9th record since i gave content 9, but i want it be dynamically update

so not sure how to replace the code?

[lbendlin]

but i want it be dynamically update

based on what? Where does your desired row index come from?

[lbendlin]

What does "selected"  mean?  Power Query has no concept of that.