Forum Discussion
Pivot - Adding calculated fields between value-fields
That's with data model and DAX measure. They could be relatively simple, everything depends on how your data is structured. Bunch of possible patterns is here Standard time-related calculations – DAX Patterns
Thanks for your response but this isn't what I'm looking for (my bad, sorry).
Made an example of a pivot-table which I've got and added the 'current year vs. previous year' calculations to the right of the pivot (yellow circle).
My question is: Can I somehow make calculated items / fields in pivot table which show me these differences? And would these calculated fields be smart enough that if I choose to filter on eg years 2019 and 2020 in pivot then the only comparison I'd see is Delta 2020 vs. 2019?
Depends on how your source data is organized. As variant that could be
which gives result as on your screenshot.
