Need Help with Sum

[Meghbajaj]

Hi Community,

I want to understand if the following result can be obtained by a measure or need to add a new column? If possible to do by measure, please suggest the formula. Thanks in advance.

[ryan_mayu · Accepted solution]

@Meghbajaj 

you can try to create a column

Column = sumx(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])&&year('Table'[Salary Start Date])=year(EARLIER('Table'[Salary Start Date]))),'Table'[Salary])

pls see the attachment below

[FreemanZ]

hi @Meghbajaj 

could you elaborate the logic behind?