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] )
    )
)
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
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] )
    )
)
madan27's avatar
madan27
Frequent Visitor
9 years ago

Thanks Vvelarde. I got the required ouput.