Forum Discussion

GlitchedDuck's avatar
GlitchedDuck
Frequent Visitor
4 years ago

Average Count Per Day/Week/Month Card

Hi All,   I'm trying to create a few card visualization that shows average amount of invoices per Day/Week/Month.   In my data i have created_date, Invoice_Number and want to show the average in ...
Need Help
johnt75's avatar
johnt75
Super User
4 years ago
Average per day = AVERAGEX( ADDCOLUMNS( VALUES(date_dim[full_date - No Time]), 
   "@val", CALCULATE([Invoice Count]) ), [@val])

Average per month = AVERAGEX( ADDCOLUMNS( SUMMARIZE( date_dim, date_dim[Year month]),
   "@val", CALCULATE([Invoice Count]) ), [@val])