Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Cumulative sum by month

  • 1.  Cumulative sum by month

    Posted Jul 26, 2021 07:06 PM
    Edited by Dumidu Roshan Jul 26, 2021 07:07 PM
    I have excel table, where in "Totals" column i have the accumulative totals per day
    Date, Month and Units are dynamic date that are synced via a server

    Formula in "Totals" being
    =SUMIFS([Units],[Month],[@Month])-(SUMIFS([Units],[Month],[@Month])-[@Units]) + IF(B1=[@Month],+D1,0)​
    how do i replicate this formula in a power query table that only has the Date, Month and Units columns?

    Any help is highly appreciated
    Thank you,

    Dumidu Roshan
    Power Platform Enthusiasts

  • 2.  RE: Cumulative sum by month

    Posted Aug 03, 2021 09:14 PM

    This looks like a Cumulative total question ? See this.


    Philippe Addelia
    Director of Business Intelligence
    Upland CA

  • 3.  RE: Cumulative sum by month

    Posted Aug 04, 2021 04:22 AM
    Hi Dumidu,  I think you should just be able to use the DATESMTD function in DAX

    Alison Box
    Power Bi Consultant