topic Re: current 12 dates in Report Server

current 12 dates

archana_c — Fri, 26 Aug 2022 06:20:50 GMT

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?

Re: current 12 dates

v-henryk-mstf — Mon, 29 Aug 2022 08:20:50 GMT

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.

link:

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,
Henry

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

Re: current 12 dates

archana_c — Mon, 29 Aug 2022 10:07:28 GMT

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.