Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a model with the Fact table and the date dimension. How can I rolling average by n days considering the dates that do not have sales included within a 7-day moving average, for example?
I used this formula but it only consider days with sales
Solved! Go to Solution.
Try replacing blanks with 0.
Ventas = IF( ISBLANK(SUM([value])), 0, SUM([Value]) )
Hi,
This pattern should work
Measure = divide(calculate([Amount],datesbetween(calendar[date],min(calendar[date])-6,max(calendar[date]))),7)
Hope this helps.
Hi,
This pattern should work
Measure = divide(calculate([Amount],datesbetween(calendar[date],min(calendar[date])-6,max(calendar[date]))),7)
Hope this helps.
Try replacing blanks with 0.
Ventas = IF( ISBLANK(SUM([value])), 0, SUM([Value]) )
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |