Forum Discussion
Relative Date Parameter in Power Query
Is there a way to configure a Parameter in Power Query so that it is RELATIVE (to the current date or date of the refresh)? I have some tables with several million rows and would like to limit it...
HI.
I have just find a tricky solution by adding new "Age" column from date and then transform the age to duration, after that you can select the period you want depending on your current date
regards,