Need Current Year value based on the Last Year value also

[#1]

Hello All,

I have a scenario,

I am showing one value, The value should satisfy two condition.

I have today, today my revenue is less than 95%

same day last year my revenue is less than 95%.

now i should consider this year value.

so i need to write a expression if year=current year and Revenue <95%, Year=PY and revenue<95% then Revenue for today

any help to write this condition

Thanks

[#2]

If value is less than 95% in both years then only i consider the value, other wise i should ignore the value

[MK_QSL · Accepted solution]

Create a Straight Table

Dimension = Month

Expression

IF(SUM({<Year = {'$(=Max(Year))'}>}Value) <0.95 and SUM({<Year = {'$(=Max(Year)-1)'}>}Value) <0.95, SUM({<Year = {'$(=Max(Year))'}>}Value))