Forum Discussion

SwathiKundar's avatar
SwathiKundar
Frequent Visitor
4 years ago

Average Daily Spend

Hello All. I need to calculate the Average Daily Spend. Average Daily Spend = Total cost / Avg Days for the selected period. ex: If we select the period 1 to 25 then Average days should be 25. ...
Need Help
Show and Tell
V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Hi SwathiKundar ,

 

Please try to create a measure like below:

Measure = SUMX(VALUES('Table'[Month]),[AVG Daily Spend])

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.