1 of 1 people found this helpful
Create a calculated field that looks like this and call it Current Year Revenue If Year = [Current Year Parameter] then [Revenue] else 0 then set up another calc field as Comparison Year Revenue as Year = [Comparison Year Parameter] then [Revenue] else 0 then Third calc that compares those 2 fields for your Variance calc. That should get you the answer you're looking for.
A small follow up question: Is it then possible to have these parameters multi-select a filter for the rest of the dashboard? I have graphs outside of this table, and in this instance we would want the graphs to be filtered on the Current Year and the Comparison Year. So in the above example I would want to filter the year on 2018 and 2016. I know how to do one single comparison through the formula condition in the filter, but I'm not sure how to do multiple parameters.