Sheet action to filter date on opening sheet

[zakpullen]

Hi,

This seems like it should be straightforward, but it's not working for me. I want a latest date to be selected when a particular page is opened. I've added the sheet action as follows.

The full value is '=Max({1}PDR_ReportDate)'. It works fine in a KPI object, but nothing happens when I use it in the sheet action.

Many thanks

[lukas_ · Accepted solution]

Hi,

You should try this : 

=num(max({1}[PDR_ReportDate]))

[zakpullen]

Excellent. Thank you!