Showing results for 
Search instead for 
Did you mean: 
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)



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




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.




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