Forum Discussion

SBC's avatar
SBC
Helper III
3 years ago

How to create dynamic date paramters in power query

Hi,

I have paramter in the power query

 

 

 

We are going to pull the data based on the date we enter in the paramter,

 

I want to make this as dynamic should pull the latest date data from a table, some latest dateshaving data some dates no data is  pulled so we need to pull only the latest date data  in power.

Can we achieve this requirement?

 

 

Thanks,

SBC

 

 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    Yes. You can use Date.From(DateTime.LocalNow()) to use today's date in any expression (or used Date.AddDays() to shift from that. Or you can use the Table.Max() function to keep only the rows for the max date from a given table.

     

    Pat

    • SBC's avatar
      SBC
      Helper III
      3 years ago

      Hi ppm1 ,

      Thanks for giving reply,can you  provide detail explanation how to apply  steps in power query to create paramter.

       

      Thanks,

      SBC

      • ppm1's avatar
        ppm1
        Solution Sage
        3 years ago

        I should have mentioned that I was suggesting you not use a parameter but use those dynamic functions in your query/expression. If you give more details and maybe mock data from your scenario, the community will give a more detailed response.

         

        Pat