Forum Discussion

一棵黄葛树's avatar
一棵黄葛树
Helper II
1 year ago
Solved

Dynamic parameter in Power Query

Can a new parameter in Power Query be a dynamic date? Such as: Dynamically return the last month-end date of the month in which today falls: = Date.AddDays(Date.StartOfMonth(DateTime.LocalNow()), -1...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Hi 一棵黄葛树,

     

    Thank you for the update. We sincerely apologise for the inconvenience caused.

     

    Please find attached the PBIX file and a screenshot for your reference, which may assist in resolving the issue.

     

     

    If you find our response helpful, kindly mark it as the accepted solution and consider providing kudos. This will assist other community members facing similar queries.

     

    Thank you.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Hi 一棵黄葛树,

 

Thank you for the update. We sincerely apologise for the inconvenience caused.

 

Please find attached the PBIX file and a screenshot for your reference, which may assist in resolving the issue.

 

 

If you find our response helpful, kindly mark it as the accepted solution and consider providing kudos. This will assist other community members facing similar queries.

 

Thank you.

  • 一棵黄葛树's avatar
    一棵黄葛树
    Helper II
    1 year ago

    Thank you very much. Perfect has solved my problem and I feel the continuous attention and patient explanation. Previously, I misunderstood that it was creating a new step, not a new query.