+ Reply to Thread
Results 1 to 1 of 1

DAX power pivot Cumulative averages

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

    DAX power pivot Cumulative averages

    Hi,

    I want to a cumulative average by date and have come up with tow formulas both correct in their own way, but I think one is more efficient but doesn't give tithe answer I wanted, the other does but been told it'Not a good way of doing calculations,

    the two are ;

    Please Login or Register  to view this content.
    This will give an average of all the dates on which sales were made, then,


    Please Login or Register  to view this content.
    this gives an average of the aggregated dates, so in you have ten 10/01/2020 it will still only count as one, but as said have been told that this is not a good way of doing a cumulative total so replacing AVERAGEX with SUMX.
    Is there a way to use the first measure but make it only count each date once? Workbook attached.

    Richard.
    Attached Files Attached Files

+ Reply to Thread

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 cumulative Average by grouping
    By Dicken in forum Office 365
    Replies: 3
    Last Post: 09-16-2022, 09:53 AM
  2. [SOLVED] Power Pivot/Query: Cumulative inventory based on future sales
    By 63falcondude in forum Excel General
    Replies: 5
    Last Post: 06-20-2022, 09:08 AM
  3. Replies: 1
    Last Post: 09-11-2019, 03:07 AM
  4. 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
  5. Replies: 4
    Last Post: 03-13-2015, 05:34 AM
  6. Replies: 9
    Last Post: 05-15-2014, 01:57 PM
  7. Find cumulative averages
    By bigband1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2012, 05:31 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