I am dealing with 4 car dealerships.
I want to determine which dealerships are growing over the previous year based on the current week of the year.
Here's my thought process:
Sum(Sales2022[Current Week])-Sum(Sales2021[Same Week Last Year])=X
I then want to Declining = COUNT where X < 0
There are 2 dealerships declining based on this formula.
-----
I have been playing around with variants of these but am at a complete loss:
[Date]={"=inweek([Date],today(1),-1)
[Date]={"=inweek([Date],today(1),-53)
I can gather the sales of each week and then I can subtract them but it is the count of this subtraction that appears to be giving me trouble.
SUM({<[Date]={"=inweek([Date],today(1),-1)"}>}[Sales])
-
SUM({<[Date]={"=inweek([Date],today(1),-53)"}>}[Sales])
How would I approach counting the above where each dealership is negative (decline?)
