12-11-2018 04:24 AM - edited 12-11-2018 04:42 AM
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 any months with no values in the formula. Below you will notice there is no values for March and May because of low sample size; however, we do want that to be included in the average because when folks are looking at this data YTD they will compare it to the overall YTD average and it all should match.
Link to file:
12-11-2018 05:19 AM
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.
12-11-2018 05:55 AM
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.
12-11-2018 06:06 AM
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.