Compare Current and Previous Year

[Zwakele]

I'm clueless where to start. I'm happy to provide more info. needed.

I have a report I want to show current year by month (total) and I want to compare values with the previous years by month.

On Excel, I used the Value Field Settings to show values as Difference from Based field [Year] and Base items [next]

[v-shex-msft · Accepted solution]

Hi @Zwakele,

You can take a look at below sample.

Table: Date,Amount.

Add a measure to calculate previous data.Pervious Year Total =
var currDate=MAX([Date])
return
SUMX(FILTER(ALL(Shipments),Shipments[Date]>=DATE(YEAR(currDate)-1,1,1)&&Shipments[Date]<=DATE(YEAR(currDate)-1,12,31)&&MONTH([Date])=MONTH(currDate)),[Total Revenue])

Improve % = FORMAT( DIVIDE(SUM(Shipments[Total Revenue])-[Pervious Year Total],[Pervious Year Total],0 ),"Percent")

Create a matrix to show the result.

Regards,

Xiaoxin Sheng