Forum Discussion
Average to include blank months
Hello, is there a way that my formula can include blank months.. I am using the below formula and would like to be able to get an average of 19.06 instead of 27.24. However, Power BI will exclude...
You're not working with a date table. This causes you to have no blank data at the missing months because those missing months are not actually there for that category.
What I believe is that you should create a dimension table. It can be date dimension table or only a single column with months. Then you can create relationship and show the months with 0 values.
Can you show me how I could accomplish this with the creation of a date table? The pbix is above. I have a date table in my original file set I just shorted this one down and provided dummy data to try and give a sampel file for assistance.
