Forum Discussion
Daily Average MTD
Yep, that's great. Assuming your calendar table follows the rules for in built time intelligence functions (read here http://exceleratorbi.com.au/power-pivot-calendar-tables/) you can use the following formulas
Sales MTD =TOTALMTD(factsales[sales amount])
total sales days = distinctcount(factsales[date])
daily average = divide([sales mtd],[total sales days])
i think this will do what you want
Yep, that's great. Assuming your calendar table follows the rules for in built time intelligence functions (read here http://exceleratorbi.com.au/power-pivot-calendar-tables/) you can use the following formulas
Sales MTD =TOTALMTD(factsales[sales amount])
total sales days = distinctcount(factsales[date])
daily average = divide([sales mtd],[total sales days])
i think this will do what you want
This is fantastic! I am using the built in time intelligence. Appreciate it!
I think where I was missing with the calculation was that I was trying to do it all in one line of code versus breaking it down to 3.