Forum Discussion

madan27's avatar
madan27
Frequent Visitor
9 years ago
Solved

SUM current and Previous records

Hi,   I am having a table as below   Year Designation Salary 2010 Engineer 50000 2010 Sr.Engineer 70000 2010 A.Manager 90000 2011 Engineer 55000 2011 Sr.Engineer 750...
Need Help
Show and Tell
Tips and Tricks
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    madan27

     

    Hi, try witt this DAX

     

    Salary running total in Year =
CALCULATE (
    SUM ( 'Table1'[Salary] ),
    FILTER (
        ALLEXCEPT ( Table1, Table1[Designation] ),
        Table1[Year] <= MAX ( Table1[Year] )
    )
)
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi madan27

 

In the expected output you have two Engineer records for 2011.  Should one of these be for 2012?

 

madan27's avatar
madan27
Frequent Visitor
9 years ago

Yes Phil, your correct. Sorry for the typo....