Forum Discussion
Excel Power query
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
7 Replies
What does "selected" mean? Power Query has no concept of that.
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?
but i want it be dynamically updatebased on what? Where does your desired row index come from?
Use this formula for year 2023
= List.Transform({1..12}, each Date.EndOfMonth(#date(2023,_,1)))thanks but i have approached parameters concept
Change the 9 in [Content]{9} to the name of your parameters like [Content]{#"The parameter giving the number of the desired month end"}
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
