Before function query

[anagharao]

Hi Everyone,

How can I use before function when there are 2 or more columns used in a pivot table. For example:

Table:

Actual		Budget
2021	2022	2021	2022
34	56	45	77
...	...	...	...

I want to add a column that will compare relevant actual and budget periods

Actual				Budget
2021		2022		2021		2022
Value	Before	Value	Before	Value	Before	Value	Before
34	-	56	-	45	34	77	56
...	...	...	...	...	...	...	...

Value and before being the two measures.