Results 1 to 6 of 6

DAX power pivot Average

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    768

    DAX power pivot Average

    I'd like to calculate the average for the total of sales for each month, per sale date not the total number of days per moth.

    So in excel it would be
     SUM(F4:F11) /COUNT(E4:E11)
    summed units / count of sales dates.

    I've used

     Total Monthy:=VAR Mtotal = CALCULATE([Totalsales],ALL('Calendar'[Date]),VALUES('Calendar'[Month]) )
    RETURN IF([Tsales],Mtotal)
    To give me the total sales for each month but can't sum the number of dates for each month. I have tried various
    AVERAGE, AVERAGEX option, but cant get the correct granularity,

    I've attached a workbook with attempts and excel table with what I'd like to achieve.

    Richard
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Pivot DAX average calculation of a time period
    By Dicken in forum Office 365
    Replies: 4
    Last Post: 10-18-2022, 11:56 AM
  2. [SOLVED] Power Pivot DAX cumulative Average by grouping
    By Dicken in forum Office 365
    Replies: 3
    Last Post: 09-16-2022, 09:53 AM
  3. Replies: 2
    Last Post: 12-17-2021, 08:41 AM
  4. [SOLVED] Power pivot can't calculate average because of text in column
    By beastiaan in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-20-2021, 08:43 AM
  5. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  6. Replies: 15
    Last Post: 03-29-2018, 11:29 AM
  7. Power Pivot or just regular Excel weighted average formula
    By stevemkiidub in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2015, 12:17 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1