I’m trying to create a slice of table “Inspections” to get the last inspection recorded for each rego, but only if that inspection’s status is due or overdue.
So it would be something like:
- Filter [rego]
- Select rows where [Status] equals “Due” or “Overdue.”
- Select the record with the recent date
I have tried different expressions, but none of them has given the expected result.
The last try I did was create a slice “Rows_Due_Overdue” to get all the rows where [Status] equals “Due” or “Overdue” and then create a second slice “Recent_Record” to get the MAX record. The expression I have for “Recent_Record” where “Inspections” is the source table is the following:
([_ROWNUMBER] = MAX(Rows_Due_Overdue[_ROWNUMBER]))
It’s not working and I do not know what else to try
It would be great if I can get some help, please, pleeease!
Thanks in advanced!