+ Reply to Thread
Results 1 to 1 of 1

DAX Average for year

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

    DAX Average for year

    Hi,
    I do have what I want but is there a better way of doing this?
    I want to calculate the average sales for each year based on the sum of monthly totals,

    I've first tried;

    Please Login or Register  to view this content.
    Which give the total per year and then divides by 12, after a few more attempts I used crossjoin with ALL and VALUES;


    Please Login or Register  to view this content.

    so if anyone knows a better way please let me know.


    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. DAX average for Year
    By Dicken in forum Office 365
    Replies: 2
    Last Post: 01-06-2023, 09:40 AM
  2. [SOLVED] Get average of all averages that are in the same year
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2021, 02:28 AM
  3. Help with averageifs formula.
    By LorenzoCastroC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-02-2020, 12:44 PM
  4. [SOLVED] Average by year if data in the same year
    By Sarin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2018, 05:33 AM
  5. Vertical Bar ( Year Average)
    By kuzna26 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-02-2013, 01:19 AM
  6. average for month, 1/4 year, year
    By miheec in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2012, 06:34 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