I was trying to create a comparison between current month & last month sales based on the same weekdays.
When we use Dateadd with month we are comparing 01-02-2022 with 01-01-2022 .
In my scenario i want to compare,
If 01-02-2022 is a tuesday, i want to compare it with the first tuesday of previous month. ie 04-01-2022.