Forum Discussion
Same Week last Year Flag
Hey all, Apologies in advance as I'm fairly new to more complex DAX functions. I'm attempting to create a column that flags whether or not a product was being sold in the same week last year ...
I'm still having an issue with this one. I've tried a couple of the solutions offered here but nothing seems to be giving me the desired outcome. As a sample table below:
In this instance, I would be trying to flag down 'Brand C' because it was sold in the same week as last year.
| Brand | Dates |
| Brand A | 1/1/2021 |
| Brand B | 1/2/2021 |
| Brand C | 1/3/2021 |
| Brand D | 2/1/2022 |
| Brand C | 1/3/2020 |
| Brand B | 1/1/2021 |