Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I show just the most recent dates for TRAILER?
Thanks. Had to use Aggr(max(LAST_INSPECTION_DATE),TRAILER).
AddYears(max(total <TR> [Last Day]),1)
I want to make sure I'm doing this right. I tried this and it didn't go through. Is this correct?
How can I show just the most recent dates for TRAILER?
Is TRAILER and LAST_INSPECTION_DATE the only columns in your table? Then you could try to keep TRAILER as a dimension, but remover the LAST_INSPECTION_DATE in favour of a new measure column with this expression:
Dayname(Max(LAST_INSPECTION_DATE))
I have these columns
Thanks. Had to use Aggr(max(LAST_INSPECTION_DATE),TRAILER).