Forum Discussion

一棵黄葛树's avatar
一棵黄葛树
Icon for Helper II rankHelper 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.

AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
1 year ago
Date.AddDays(Date.StartOfMonth(DateTime.LocalNow()), -1) meta [IsParameterQuery=true, IsParameterQueryRequired=true]
  • 一棵黄葛树's avatar
    一棵黄葛树
    Icon for Helper II rankHelper II
    1 year ago

    Thanks for the answer, but I don't know where to add this meta, could you make a PBIX attachment for me, much appreciated!

    • AlienSx's avatar
      AlienSx
      Icon for Super User rankSuper User
      1 year ago

      create blank query and paste this code over there

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

        Thanks for replying again, maybe I wasn't clear before.
        I was hoping to create a new parameter in Power Query (dynamically display a date, e.g. if today is 2025/2/21, then the date at the end of the last month will be: 2025/1/31), and then use to call that parameter in other queries.
        Such as table table, filter 20251/1/31 before all rows of data.