Forum Discussion

VJ_Lsf's avatar
VJ_Lsf
Frequent Visitor
1 year ago
Solved

Cumulative sum

Hi, I need help with creating a measure for calculating cumulative sum by technician. I also have a date column in addition to 2 columns below. Cumulative total by Technician column is what I need. ...
Need Help
  • Cookistador's avatar
    Cookistador
    1 year ago

    Hi VJ_Lsf 

    Hello,

    I made a small test:

     

    As mentionned, with your query I get the third line 

    The sum is done by month (9 then 18 and 33)

     

    To get the sum by Date AND Techncian, you have to add the technician in the column

    you just have to add:

    'Table'[Technician] = MAX('Table'[Technician]) in your dax query, so your new measure becomes
     
    Cumulative Total by Date & Technician =
    CALCULATE(
    SUM('Table'[Value]),
    FILTER(
    ALLSELECTED('Table'),
    'Table'[Date] <= MAX('Table'[Date]) &&
    'Table'[Technician] = MAX('Table'[Technician])
    )
    )

     

     

     

mdaatifraza5556's avatar
mdaatifraza5556
Icon for Super User rankSuper User
1 year ago

Hi VJ_Lsf 

Can you please try the below DAX?

Cumulative Sum by Technician =
                                     CALCULATE (
                                                 SUM ( 'Table'[value] ),
                                                 FILTER (
                                                     ALLEXCEPT ( 'Table', 'Table'[Technician] ),
                                                    'Table'[date] <= MAX ( 'Table'[date] )
                                                 )
                                      )


If this answers your questions, kindly accept it as a solution and give kudos.