cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Calculate 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 Amount Previous year Amount 2018 100 2019 200 100 2020 300 200
1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Super User

@AOD , If you need this as a new column

last year = sumx(filter(Table, [Year] = earlier([Year]) -1) , [Current year] )

for measure prefer to have separate year table(say Date) joined to this table

Curr Year = CALCULATE(sum('Table'[THis year]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[THis year]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors