I tried searching for this already as I assumed it was a common question but did not find it. I am looking to do sales(or revenue) by day that dynamically adjusts as you cycle through the date from day, week, ..., year.
It just needs to be sum(sales)/(# of days in period) but data types do not work for sales/count(date). At first I thought about LODs, but nothing is being fixed as both the total sales and the number days is changing. Has anyone found a solution for this seemingly easy problem?
Nevermind. The solution is just to use a Distinct Count and sum of revenue.
Hopefully, everyone else realizes this easy answer before seeing my post but just in case, it is here.