Forum Discussion

Jaunkalns's avatar
Jaunkalns
Frequent Visitor
8 years ago

Help with measures

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!

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    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's avatar
      Jaunkalns
      Frequent Visitor
      8 years ago

      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?