Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

sum complete last year (Year to Year -1)

Hey Guys, 

 

i need your help, please. 

 

I want to measure the Total amount of the last year (YTY-1).

But i have one restiiction: I am using a measure of the YTD. If I filter the month, I get the YTY-1 with filtered values too. But it should measure the total value of the last year

 

Best regards from Germany 🙂

 

my current measure: 

NMVA06_0-1670940624790.pngcurrent_measure.PNG

 

1 ACCEPTED SOLUTION
TomasAndersson
Solution Sage
Solution Sage

Hi!

Do you have a Date table (Set and use date tables in Power BI Desktop - Power BI | Microsoft Learn)?
If so, PREVIOUSYEAR() should work, in the form of:

AA_Betrag_YTY-1 := 
CALCULATE(
    [korrigierter Betrag], //assuming this is the measure you want to calculate
    PREVIOUSYEAR(Dates[Date]) //date column from your date table
    )

 

View solution in original post

2 REPLIES 2
TomasAndersson
Solution Sage
Solution Sage

Hi!

Do you have a Date table (Set and use date tables in Power BI Desktop - Power BI | Microsoft Learn)?
If so, PREVIOUSYEAR() should work, in the form of:

AA_Betrag_YTY-1 := 
CALCULATE(
    [korrigierter Betrag], //assuming this is the measure you want to calculate
    PREVIOUSYEAR(Dates[Date]) //date column from your date table
    )

 

Anonymous
Not applicable

Hi Tomas

yeah, it works well. I know one more function now too. Thanks for that!

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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