Forum Discussion
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 ...
Thist just seems to be giving me back the total number of invoices
GlitchedDuck Wrap it with DAY function.
Day = Averagex(Values(DAY(DateTable[DateColumn])), [Invoice Count])