Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm having some trouble calculating Sales/Store/Day.
This is how i wrote the code which i'm sure is the incorrect way. It works when looking week level but when i go to individual dates it's incorrect.
Weeks = COUNTA('Date Table'[Date])/7
U/S/W = [Unit Sales]/[Stores]/[Weeks]
U/S/D = [Unit Sales]/[Stores]/[Weeks]/7
Stores = CALCULATE(DISTINCTCOUNT(DimStore_List[STORE]),FILTER('Daily Data','Daily Data'[Net_Sales]>0))
Unit Sales = SUM('Daily Data'[Unit_Sales])
Does your [Unit_Sales] data actually have day level granularity? Or do you only want to divide the weekly numbers by 7 ?
That's is actually the tricky part. My data is a combination of day level and week level. Some day will have one date that represents the entire week and other would have each day.
For background context this model is a combination of multiple Retailer Data. I shown the days here, but we actually only look at the data by week but now want to see Unit Sales per Store Per Day.
Full week in one day
Daily day
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |