Date parameter for Previous date

[Rocky_PBI]

Hi Experts ,

I have one requiremnet in Power BI, i have multiple tables in power querry every table need to filter on date column by using date parameter. How to create current date -1 parameter which will give previous day data. I only need create in power querry. any solution for create date parameter and how will pass it on my date table.

[TheoC]

@Rocky_PBI 

I'm not sure whether I've understood what you want correctly. But hopefully this is right:

1. In Power BI Desktop, go to the "Home" tab, then click on "Transform Data" to open Power Query.
2. In Power Query, go to the "Manage Parameters" section, then click on "New Parameter."
3. Name the parameter (e.g., "PreviousDay").
4. Set the parameter type to "Date."
5. For the "Current Value," use a formula to set it to yesterday's date using M code:  Date.From(DateTime.LocalNow()) - #duration(1,0,0,0). This should get today's DateTime, convert it to a Date, then subtract one day.
6. For each table where you want to apply this filter:
   • Select the table in Power Query.
   • Go to the date column that you want to filter.
   • Apply a date filter but instead of selecting a specific date, select the "Date/Time Filters" and then "Custom Filter."
   • In the filter dialog, set it to show rows where the date column is equal to the parameter you created.

Theo

[Rocky_PBI]

Hi @TheoC 

Thanks for replying... Will try that way. But the main motive is  When user run the report he should get the date prompt popup then he will select the dates ranges