Forum Discussion
Anonymous
8 years agoNot applicable
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
Microsoft Employee
Hi Anonymous,
Seems you have gotten the answer from this post, haven't you?
Best Regards,
Dale
- AnonymousNot applicable
Yes. Thank you.