Forum Discussion

archana_c's avatar
archana_c
Helper I
3 years ago

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 dat...
@current12dates
@Dax
@need help
@paginated report
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

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.

  • archana_c's avatar
    archana_c
    Helper I
    3 years ago

    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.