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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.