Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

current 12 dates

how do i display current 12 dates with a date selected as parameter?


I have a report with a date field, where i should display only the current 12 dates where the maximum date is the selected date from the date parameter. Is there any way i can bring it up in the powerbi report builder?



Community Support
Community Support

Hi @archana_c ,


You can create date parameters to view the records under the specified filter. Refer to the following document for detailed steps.

  • The report parameters in the Report Data pane.
  • The dataset with the parameters.
  • The Parameters pane.
  • The parameters listed in the Dataset Properties dialog box.


Report parameters in Power BI Report Builder - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hi @v-henryk-mstf 

I went through the documentation. But couldn't find the right solution . Is there any calculation i can write for getting the 12 dates, where the maximum date would be the selected date in the date parameter.
There should only be one date parameter.

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.