I want to create a table of contract values - current active contract vs prior year contract where the contract has been renewed.
I think I’ve calculated the PY and variance correctly however when I filter the table for renewals only it also removes the contracts that weren’t renewals that make up the PY value
ie Contract A 2019 - 2020 Value £1000 is a new contract - it renews 2020-2021 £1200 and is marked as a renewal contract
Contract B is a new contract 2020-21
I want to calculate a table of renewals only ie
Contract Current £ PY £ Variance
Contract A 1200 1000 200
At the moment becuase I’m filtering on Renewal True/False it excludes the original contract A value
How can I fix this?
C Anal Test.pbix (177.1 KB)