Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

YOY Growth Question - Previous Year not Calculating

Hello,  I have read multiple posts on this. I created a small sample file to test YOY growth - starting with getting total for previous year.  My previous year total is not calculating correctly- gives me total again for current year.  I am sure there is a simple solution to this.   I would like to upload my very small Power bi file but do not see a place to do this.   My sample file just has 3 fields:

 

Year  Clicks  Vertical

2016  1000   Home

2017  2000   Home

2016  2000   Wedding

2017  3000    Wedding

 

I also created a DateKey Table with a date field and a Year Field. 

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Anonymous,

     

    Seems you have gotten the answer from this post, haven't you?

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes.  Thank you.