Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community. I want to filter a straight table using the 'Max' report date found in the data. The process will create a new record / Report Date each month. The user wants to either the selected or 'Current (Max date)' when no field is selected.
See attached for example
Thank you!
Brett
Hi,
Please find attached
I've created a variable MaxReportDate =Max(Report Date)
and used this expression:
=Only({<[Report Date]={'$(MaxReportDate)'}>}[Report Date])
Hi,
Please find attached
I've created a variable MaxReportDate =Max(Report Date)
and used this expression:
=Only({<[Report Date]={'$(MaxReportDate)'}>}[Report Date])
hello,
depending on the context, this might be usefull too, please see attachement.
I have created a trigger to select in the field [Report Date] the max date when the report is opened
for your information: