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 date from the date parameter. Is there any way i can bring it up in the powerbi report builder?

 

 

@current12dates
@Dax
@need help
@paginated report

2 Replies

  • 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.