Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am trying to find the 10 week average for Leads and TotalLeadCost columns. Below is what my data looks like. I would like to find the 10 week average for each column. If I can do this with one calculation that would be great. But it's okay if I cannot do it with just one calculation. If you need me to send raw data I can do that.
Any help is greatly appreciated.
-William F.
Solved! Go to Solution.
Hi @wfarrell,
You can use the below formula to compute the 10 week Average.
Week Avg =
CALCULATE (
SUM ( Sales[Revenue] ),DATESINPERIOD('Calendar'[Date],LASTDATE('Calendar'[Date]),-70,DAY))/10
Regards
CLR
Hi @wfarrell,
You can use the below formula to compute the 10 week Average.
Week Avg =
CALCULATE (
SUM ( Sales[Revenue] ),DATESINPERIOD('Calendar'[Date],LASTDATE('Calendar'[Date]),-70,DAY))/10
Regards
CLR
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |