Results 1 to 1 of 1

Power Pivot DAX Monthly average

Threaded View

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

    Power Pivot DAX Monthly average

    Hi,

    I've got the reuslt I want, which is a monthly average but I'm not sure if there's a better way, first I'm getting the avarage using ;

     AvgUnit:=AVERAGEX(VALUES(Table1[Date]),[Total Units])

    And then Calculate ;

       CALCULATE([AvgUnit],ALL('Calendar'[Date]),VALUES('Calendar'[MMM-YYYY]))
    Is there a better or alternate way of doing this, also I did try using variables but that didn't work I'm preusuming due to not being affected by the calculation filters.

    Example attached.

    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] DAX power pivot Average
    By Dicken in forum Office 365
    Replies: 5
    Last Post: 12-04-2022, 12:33 PM
  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. Calculate monthly average in pivot table
    By SpongeySquidge in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-01-2021, 07:04 PM
  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. Monthly Average in Pivot
    By ryan9867 in forum Excel General
    Replies: 0
    Last Post: 10-10-2011, 12:49 PM
  7. Getting Pivot Table to give monthly Average
    By ChemistB in forum Excel General
    Replies: 6
    Last Post: 09-27-2010, 02:03 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