Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i get a different dates from tables like
01.01.2016
01.02.2016
01.03.2016
How can i get the latest date of existing data?
regards,
sam
May be like this:
Max({<Measure= {'*'}>}Date)
Measure can be any field which is available in your fact table.
Its a placeholder for a field from your fact table. and Date is a placeholder for your date field
If your dates are interpreted as dates and read in as duals, try
=Max(DATEFIELD)
or
=Maxstring(DATEFIELD)
Hi.
the latest date i have is 30.11.2016.
I try Max and Maxstring and get 31.12.2016.
But the result must be 30.11.2016.
regards,
sam
May be like this:
Max({<Measure= {'*'}>}Date)
Measure can be any field which is available in your fact table.
I get an error message: "Wrong fieldname: Date"
Is Date like "Measure" a placeholder or a function?
Its a placeholder for a field from your fact table. and Date is a placeholder for your date field
ah ok, now it works, thank you 🙂
s Walter wrote:
Hi.
the latest date i have is 30.11.2016.
I try Max and Maxstring and get 31.12.2016.
But the result must be 30.11.2016.
regards,
sam
Seems like there is some context missing.
Please explain your data model and your requirement.