Filter by max of date in Paginated report

[Chaithanya6]

Hello,

I need to filter paginated report with max of date. 

However, I am getting the error.

I have column in my data  and I made the column to date/time

in the filter I have taken that datecolumn and added max(date). However I am getting error as aggregated function can not be added to filter

Please let me know for any work around

[v-stephen-msft]

Hi @Chaithanya6 ,

One workaround is to create a parameter in the report that allows the user to select the maximum date value, and then use that parameter in the filter. You can create a parameter. Then, you can use the parameter in the filter by selecting the column and choosing Filter, and then selecting the parameter from the drop-down list.

Create parameters for paginated reports in the Power BI service - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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