SeanDonovan's avatar
SeanDonovan
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Fantasy Football Draft Kit

Football season is upon us!  If you are a fan like me, this is the time of year to get together with family and friends to participate in the annual tradition of Fantasy Football.  This mostly friend...
Sports
jnpb's avatar
jnpb
Icon for Helper I rankHelper I
4 years ago

Hi Sean, 


Downloaded the PBIX you added - what a great implementation! 

One thing I'm struggling with is with adapting this to our league's scoring system. I can't seem to figure out how to add a Kick20Points (0-19 FGs in our league are 2 pts, 20-39 are 3). Any advice on how I could make this change? 

Disclaimer: have only been using PBI for a very short while, so am stumbling my way through it. 

Thank you in advance for any insight you might be able to offer!

 

SeanDonovan's avatar
SeanDonovan
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

A new "What-If" parameter (Kick20Points) will need to be added to the report first.  Once that is created, the "Fantasy Points" measure will need to be modified to account for the additional scoring rule.

 

I was able to make the change and attach a modified PBIX file from the post above.

  • jnpb's avatar
    jnpb
    Icon for Helper I rankHelper I
    4 years ago

    Sir, you've been incredibly helpful and generous with your time - thank you so much for this!