+ Reply to Thread
Results 1 to 5 of 5

Use Power Pivot (DAX) or Pivot Table (New Measure) to sum all values for specific column

  1. #1
    Registered User
    Join Date
    03-22-2019
    Location
    Los Angeles
    MS-Off Ver
    2013
    Posts
    34

    Question Use Power Pivot (DAX) or Pivot Table (New Measure) to sum all values for specific column

    Hello,

    I have a large dataset and I need to calculate the sum total for each day (which contains 23-24 data points). The dates/addresses repeat for different programs. I am having trouble creating a new measure via the pivot table or using a DAX formula in Power Pivot. Using excel formulas causes excel to freeze as it's checking millions of cells. Attached is a sample with the sum total for the day (it does not have to repeat as seen in the sheet). Thanks.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Use Power Pivot (DAX) or Pivot Table (New Measure) to sum all values for specific colu

    Using Power Query here are the expected results

    Excel 2016 (Windows) 32 bit
    G
    H
    I
    J
    K
    3
    Date Programs Total Average Max
    4
    1/1/2019
    A
    6.25
    0.260416667
    2
    5
    1/2/2019
    A
    7.3
    0.304166667
    2
    6
    1/1/2019
    B
    9.15
    0.38125
    2
    7
    1/2/2019
    B
    12.9
    0.5375
    5
    8
    1/1/2020
    B
    7.97
    0.332083333
    2
    9
    1/1/2020
    A
    10
    0.416666667
    4
    Sheet: pivot

    Here is the Mcode which I understand is readable in PBI
    Please Login or Register  to view this content.
    and finally the file.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Use Power Pivot (DAX) or Pivot Table (New Measure) to sum all values for specific colu

    HTML Code: 
    After that a pivot table.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Registered User
    Join Date
    03-22-2019
    Location
    Los Angeles
    MS-Off Ver
    2013
    Posts
    34

    Re: Use Power Pivot (DAX) or Pivot Table (New Measure) to sum all values for specific colu

    Thank you both for your help. This did the job.

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Use Power Pivot (DAX) or Pivot Table (New Measure) to sum all values for specific colu

    Thanks for the rep.

    Glad I could help.

    Thanks for marking the question solved.

+ 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. Expand just one measure in columns in Power Pivot
    By RrR2010 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-08-2019, 08:40 AM
  2. Pivot Table: Grand Total different measure from Column measure
    By chinneywow in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-07-2019, 06:22 AM
  3. DAX Power Pivot Measure Help
    By chicagolarsons in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-22-2019, 08:57 PM
  4. Power Pivot: Adding a measure to a Pivot Chart
    By jlt199 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-22-2017, 12:40 PM
  5. [SOLVED] Help Needed with Power Pivot Calculate Measure
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-13-2015, 10:09 AM
  6. [SOLVED] RANK.EQ Function in Power Pivot Measure
    By rv02 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-16-2015, 04:26 PM
  7. Excel Power pivot measure
    By eajustin15 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-12-2013, 05:16 PM

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