I want to calculate the max date to use as a dimension. The other discussion I have seen around this only address this calculation as a measure (as far as I can tell)
If I use this cacluation as a measure in a table, I get the expected result. But if I calculate it as a dimension, it gives me an invalid dimension error. I need to calculate it as a dimension to use on an axis of a bar chart.