I've been tasked with creating the below table within PBI, showing how many requests (jobs) have been completed per customer year over year, but by month (spanning all 12 months). I've found similar solutions online for either year-over-year OR month-over-month, but so far nothing I've found fits my needs and I can't work out how to adapt it accordingly.
| | January | | | February | | | March | | |
| | 2022 | 2023 | Diff (2023-2022) | 2022 | 2023 | Diff (2023-2022) | 2022 | 2023 | Diff (2023-2022) |
Customer1 | 3 | 6 | 3 | 7 | 6 | -1 | 14 | 2 | -12 |
Customer2 | 1 | 10 | 9 | 8 | 12 | 4 | 4 | 10 | 8 |
| Customer3 | 2 | 8 | 6 | 8 | 0 | -8 | 3 | 0 | -3 |
| Customer4 | 8 | 3 | -5 | 5 | 2 | -3 | 0 | 5 | 5 |
My data is stored on the same view as [customer name], [completed_date] and [requests] - multiple lines per customer, per date. The date is stored in date format, and the values in the table are a distinctcount of the requests (these are reference numbers).
Any help would be greatly appreciated!
(Apologies the table isn't the easiest to read, I've tried multiple times to format it so that the values align in the centre of each column heading, but each time it complains about invalid HTML and removes it before I can post, even when I use the built-in table formatting!)
