How to retrieve 3 previous years of data with DAX

[Anonymous]

Hei, is there a way to compact this code for showing 3 years of data?

Reservations present year :=
CALCULATE(
              SUM('ssas CustomerDocuments'[Dokumenter]);
                            'ssas CustomerDocuments'[Artikkel]="984 Reservation region1"||
                            'ssas CustomerDocuments'[Artikkel]="985 Reservation region2"||
                            'ssas CustomerDocuments'[Artikkel]="993 Reservation region3"||
                            'ssas CustomerDocuments'[Artikkel]="994 Reservation region4.";
                            DateTable[year]=YEAR(TODAY()))

Reservations last year :=
CALCULATE(
              SUM('ssas CustomerDocuments'[Dokumenter]);
                            'ssas CustomerDocuments'[Artikkel]="984 Reservation region1"||
                            'ssas CustomerDocuments'[Artikkel]="985 Reservation region2"||
                            'ssas CustomerDocuments'[Artikkel]="993 Reservation region3"||
                            'ssas CustomerDocuments'[Artikkel]="994 Reservation region4.";
                            DateTable[year]=YEAR(TODAY())-1)

Reservations two years ago :=
CALCULATE(
              SUM('ssas CustomerDocuments'[Dokumenter]);
                            'ssas CustomerDocuments'[Artikkel]="984 Reservation region1"||
                            'ssas CustomerDocuments'[Artikkel]="985 Reservation region2"||
                            'ssas CustomerDocuments'[Artikkel]="993 Reservation region3"||
                            'ssas CustomerDocuments'[Artikkel]="994 Reservation region4.";
                            DateTable[year]=YEAR(TODAY())-2)

[JosefPrakljacic · Accepted solution]

Hi Dax_New_User

I bet you will need the parallelperiod function. 

Here are some guides:

https://www.youtube.com/watch?v=yVZHbKKIzDE

https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax

If you need further help please share some example data.

If this post was helpful may I ask you to mark it as a solution and share some kudos 🙂

Have a nice day!

BR,

Josef