Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am experimenting with Power BI and wanted to find out a certain functionality.
I downloaded the NFL individual players statistics (all in one query with each year in the next row) from 2005 till 2017 and wanted to compare the development of a players performance. That is, for example, by what percentage did a Quarterbacks passing yardage change comparing years 2014 and 2015.
What could be the possible ways to achive such a measure?
Any help will be greatly appreciated!
Hi Jaunkalns,
"for example, by what percentage did a Quarterbacks passing yardage change comparing years 2014 and 2015. "
<--- Could you please clarify more details about your requirement and share some sample data for further test?
Regards,
Jimmy Tao
Yes, please see the sample table below.
I wish to see the development of a players passing yards in comparison to their previous season (This Season-Last Season/Last season).
So, for example, we can see that Sam Bradford missed 2015 with an injury, so there is no development for 2016.
Maybe there is a way to achieve this?
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |