Expression

[VishalSingh18]

Hello all, I want to develop a expression that gives value explicit of days before the max date present in data e.g max(Date): 65.8 max(Date)-1: 53.8 max(Date)-2: 66.8 max(Date)-3: 65.6 max(Date)-4: 65.7 I have tried many expression and it returns Till Date value what I want is value recorded explicitly on that day Thanks and Regards Vishal Singh

[jochem_zw]

See attached

[VishalSingh18]

I am not able to open the attachment 😞

[jochem_zw · Accepted solution]

what i did:

create a table with Date as dimension and this expression:

if(max(Total{1}Date)=Date,65.8
,if(max(Total{1}Date)-1=Date,53.8
,if(max(Total{1}Date)-2=Date,66.8
,if(max(Total{1}Date)-3=Date,65.6
,if(max(Total{1}Date)-4=Date,65.7)))))

Result