Hi,
I have a LOD [Latest Period] as:
[Date] = {FIXED : MAX([Date])}
This creates the latest day in the dataset. (31st Dec in this case)
I want it to return the latest entire month in the dataset i.e. in this case entire month of Dec 2020
I tried [Date] = {FIXED : MAX(Month([Date]))} but I am getting is just 12 which is December but I have many years of data in the dataset hence cannot apply that.
I tried MONTH([Date]) = {FIXED : MAX(MONTH([Date]))} but I am getting December for all the years in the dataset
Please find the twbx file attached for reference
Can anybody please help?
1 answer
DATETRUNC('month',[Date])={max(DATETRUNC('month',[Date]))}
