Forum Discussion
Solved
Date aggregation lastdate vs max
Having an issue here with displaying the max date for each row in my matrix When adding the date column as a value, it only gives me to aggregate it to count or count(distinct) When trying to cr...
Anonymous
Figured out the problem, it seems the measure should be MAX(table[date]) rather than MAX(table[date].[Date])
What a hassle!
Anonymous
Its a measure I'm using rather than calculated column
I'm using a matrix and trying to pivot on a group of columns with the max date as the value
The formulas you suggested gives the same results as just using lastdate/max on their own unforetunately
MaxDate=
var currdate= Max([Date])
return
currdate
