cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors