+ Reply to Thread
Results 1 to 3 of 3

Power Pivot DAX running total by Months

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

    Power Pivot DAX running total by Months

    Hi,
    is there a way to get a PP measure for a running total to recognize Month names, I've done this using field options,
    and have attached a worksheet showing this but would like to achieve the same with a measure if possible,
    I've tried this in power bi, and that does recognize the date Month names, so a matrix with Jan to Dec will give a running total if one is dropped in even if it's working off the actual date, but I don't think bi dates are the same as excel, in this case it seem they work better, in other cases, sorting, not as good.
    So, in the first pivot table I'd like to write a measure that gives the same as the field settings

    Richard.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: Power Pivot DAX running total by Months

    Hi Dicken,

    I managed to get that result by adding a calculated column in the datamodel with the formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    a measure with this formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I hope it helps
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

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

    Re: Power Pivot DAX running total by Months

    Well thats a novel way round it, didn't bother with the Month Index , just used the date so;

    Please Login or Register  to view this content.
    and it seems to work fine when the dates are removed and it's just months.
    I'm not sure it's the ideal way of solving it re efficiency but it certainly works and no one else has come up with and answer.

    Thanks,


    RD

+ 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. Replies: 0
    Last Post: 09-02-2022, 10:08 AM
  2. Replies: 0
    Last Post: 07-10-2022, 11:34 AM
  3. [SOLVED] Power Bi running total and power pivot
    By Dicken in forum Office 365
    Replies: 1
    Last Post: 07-08-2022, 02:15 PM
  4. power pivot DAX running total by criteria
    By Dicken in forum Office 365
    Replies: 0
    Last Post: 02-18-2022, 10:02 AM
  5. [SOLVED] Running total in power query with criterion
    By Dicken in forum Office 365
    Replies: 6
    Last Post: 01-10-2022, 09:33 AM
  6. Power Query Grouped Running Total
    By sle7en in forum Excel General
    Replies: 2
    Last Post: 02-13-2021, 06:30 PM
  7. Replies: 4
    Last Post: 11-15-2019, 04:13 AM

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