Forum Discussion
chq
Helper II
Helper IIYear Over Year Calculation With IF statement
I am trying to create a year over year formula that would provide the percent change, however we did not collect any data in 2020 so I need to exclude the 2020 data and have 2021 compared against 201...
Hi chq,
Add two columns as:2 Years After = DATEADD('Table 1'[Date],2,YEAR)2Years After sales = LOOKUPVALUE('Table 1'[Sales],'Table 1'[Date],'Table 1'[2 Years After])Here is the output:
Here is the demo, please try it: Year Over Year Calculation With IF statement
Best Regards,
Link
v-xulin-mstf
Community Support
Community SupportHi chq,
Add two columns as:
2 Years After = DATEADD('Table 1'[Date],2,YEAR)2Years After sales = LOOKUPVALUE('Table 1'[Sales],'Table 1'[Date],'Table 1'[2 Years After])
Here is the output:
Here is the demo, please try it: Year Over Year Calculation With IF statement
Best Regards,
Link