Forum Discussion
AOD
Helper III
Helper IIICalculate previous year total amount for current year
Hi All, Need help in Calculate previous year total amount for current year . I have Year and current year amount in source. Need Previous year amount to be derived . Year Current year Amoun...
Hi, AOD
It is solved by calculation column. First calculate the year of the previous year, and then output the total amount of the previous year.
Previous year = DATEADD ( 'Table'[Year], -1, YEAR )Previous year Amount = CALCULATE ( MAX ( 'Table'[Current year Amount] ), FILTER ( 'Table', 'Table'[Year] = EARLIER ( 'Table'[Previous year] ) ) )Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-zhangti
Community Support
Community SupportHi, AOD
It is solved by calculation column. First calculate the year of the previous year, and then output the total amount of the previous year.
Previous year =
DATEADD ( 'Table'[Year], -1, YEAR )
Previous year Amount =
CALCULATE (
MAX ( 'Table'[Current year Amount] ),
FILTER ( 'Table', 'Table'[Year] = EARLIER ( 'Table'[Previous year] ) )
)
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.