Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Hi @Anonymous,
Seems you have gotten the answer from this post, haven't you?
Best Regards,
Dale
Yes. Thank you.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |