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.