Comparing previous and current year data on a line chart

Hi priyapalanki,

if you have 2 separate tables FY16 and FY17, it's easy now.

• Create Dates table for time pattern 

Dates = CALENDARAUTO()

• Create Prev-Date Column

Prev - Date = DATEADD( Dates[Date],-1,YEAR)

• Union 2 separate tables FY16 -FY17 into 1 table: 

u = UNION(FY16,FY17)

• Create 2 calculated measure to cumpute total amount of FY16 and FY17:

FY16 = CALCULATE(SUM(u[Amount]),FILTER(all(dates),Dates[Date]=MAX(Dates[Prev - Date]) ))

FY17 = CALCULATE(SUM(u[Amount]),FILTER(all(dates),[FY16]>0 && Dates[Date]=max(Dates[Date])  ))

My sample data and sample pbix file

If this works for you please accept it as solution and also like to give KUDOS.

Best regards
Tri Nguyen