Forum Discussion
WheelchairWilly
3 years agoHelper III
My report is returning the wrong values
As you can see from the first ss, this shows that say Manchester City won the game 3-0 but when you look at when this results is converted to a report in Power BI (2nd ss) it shows that Manch...
- 3 years ago
Hi WheelchairWilly , you need to give an idea of what your power bi data model looks like and how you created the calculations for your Won, Draw, Lost, etc.
WheelchairWilly
3 years agoHelper III
For Won & Points I use [Add Column-Conditional Column]. For Draw & Lost I use Custom Column {If result = "R" then 1 else 0]
I did this for last years matches and did not encounter anything like this. I've tried everything under the sun for the last week but whatever I change I still keep getting the same problem. I got my instructions from a Power BI video-Building the English Premier League Table with Power BI - YouTube