Help with measures

[Jaunkalns]

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!

[v-yuta-msft]

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

[Jaunkalns]

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?