Forum Discussion
Solved
Current Year vs avg previous years
Dear community, I'm new to PowerBI and need help. I'm trying to display a bar graph of precipication of current year and would like a line of average of previous years precipication My chart c...
I was able to do the same, I grouped by month and created a column sum, and another column to count the no of months, I then dicided the sum by count to get average precipitation per month.
here is my visual
I was able to do the same, I grouped by month and created a column sum, and another column to count the no of months, I then dicided the sum by count to get average precipitation per month.
here is my visual