This content has been marked as final.
Show 1 reply

1. Re: If Condition with Aggregate function
Yuriy Fal Nov 6, 2017 10:43 AM (in response to Tianyue Yang)Hi Tianyue,
Hope the logic behind your calculations
could be simplified a bit in such a way:
Calculate the difference in Transaction Count between
the Maximum (Year) and the Minimum (Year)
having Years as a (Dimension) Filter,
but with the Year Dimension not present on a view.
The above logic could be implemented as LOD expression(s).
Please find the attached as an example (using Sample Superstore).
Hope it could help a bit.
Yours,
Yuri

MAXMIN_LOD_v100_YF.twbx 1.4 MB
