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
Tahreem24's avatar
Tahreem24
Super User
4 years ago

GlitchedDuck, Better to share the dummy data here (not screen shot) to understand your need.

 

GlitchedDuck's avatar
GlitchedDuck
Frequent Visitor
4 years ago
Created_DateInvoice_Number
24/03/20221
24/03/20222
24/03/20223
24/03/20224
24/03/20225
24/03/20226
23/03/20227
23/03/20228
23/03/20229
22/03/202210
22/03/202211
22/03/202212
22/03/202213
22/03/202214
21/03/202215
21/03/202216
21/03/202217
21/03/202218
21/03/202219
  • Tahreem24's avatar
    Tahreem24
    Super User
    4 years ago

    johnt75 Create one seperate Calendar table like below:

    Calendar = CALENDAR(MIN(CreatedDate),MAX(CreatedDate))

    Then create a different columns under this table:

    MONTH = MONTH(Calendar[Date])

    YEAR = YEAR(Calendar[Date])

    DAY = DAY(Calendar[Date])

     

    Then create a below Measures under your invoice table,

    Avg Invoice per Month = CALCULATE(SUM(InvoiceTable[Invoice_Number]),ALLSELECTED('Calendar'[Month]))
     
    Like wise just create for DAY and Year measure by chahing the ALLSELECTED funtion respectively.