cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
coollehavre Frequent Visitor
Frequent Visitor

compare actual year vs precedent year with kpi

Hi i have three measures like that :

[Sum Sales]=SUM([Table Sales].Amount

[Sum Sales N-1] = CALCULATE([Sum Sales];SAMEPERIODLASTYEAR(Dates[Date]))

and a measure for goal sales : 

[Sum Sales Goal] = [Sum Sales N-1]*1.1

 

This measures works fine but i would like to show a KPI tha show the [Sum Sales] vs the [Sum Sales Goal]

So i added a KPI but when i select a year he shows nothing because theres no values in [Total Ventes Objectifs] (Sum Sales Goal)

Capture.PNG

 

How to have the sales for year selected and the sales for previous year when i select a year in my slicer ?

 

Thanks

 

1 REPLY 1
v-ljerr-msft Super Contributor
Super Contributor

Re: compare actual year vs precedent year with kpi

Hi @coollehavre

 

According to your description above, I have tested it with my data. It turns out that your solution should work as expected.

 

r3.PNG

 

Could share a sample pbix file which can reproduce the issue, so that we can further assist on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. Smiley Happy

 

 

Regards