Year Over Year Comparison Skipping 2020

[chq]

My data looks like this....

Date		Ticket A		Ticket B		Ticket C		Ticket D		Ticket E		Ticket F
01/01/2020		0		0		0		0		0		0
01/01/2019		18		14		1		15		150		490
01/01/2018		14		14		1		12		154		500
01/01/2021		3		0		0		5		75		600
01/02/2020		0		0		0		0		0		0
01/02/2019		19		15		1		15		150		490
01/02/2021		3		0		1		5		76		604
01/02/2018		15		15		1		14		155		505

and my desired output is something like this....

Date		2018		Difference		% Diff		2019		Difference		% Dif		2021
01/01		695		-7		-1.07%		688		-4		-0.73%		683
01/02		705		-15		-2.13%		690		-1		-0.14%		689

The data goes back to 2005 and I would need to compare them by date going back year over year (exlcluding 2020 from the data set) Are there a set of measures that can be used to get this kind of result? So far my formulas have not worked, but I have a feeling it is my inexperience with DAX.

Thanks in advance

[lbendlin · Accepted solution]

Duplicate? Year Over Year Comparison Excluding Year - Microsoft Power BI Community