Forum Discussion
Max value date
We are trying to create a measure which shows us the created date. To determine this we use the max function (or maxx), but we will not see values. Our formula is the following:
max created date = MAX('Dim_....'[CreatedDate])
As prt screen shows, it will not give me any values. Same formula does work in the date table. Anybody any idea what can be the reason that it is not working for other values? Can it be a specific setting of the column?
12 Replies
What dataformat is [CreatedDate]?
tex628 Dataformat is date/time. Tried to change it to date as well, but that also doesn't give any output.
Well thats strange.. Because you're not wrong, MAX should indeed work in this situation.
If you take a new plain table. Add only the date column and your measure, do you get the same result?
/J
