Show dates in table

[JJ141]

Hi all,

Hope everyone is doing well. 

I have table below which highlights the usage per month from April 2020 to February 2021. As can be seen, some months such as May 2020 have been left out as there is no data for those months since the usage is 0 for those particular months. 

Is there a possible way, I can include those missing months along with 0 for the usage per month.

Any help is greatly appreciated.

[jwjackso · Accepted solution]

Create a Calendar that has all the time periods between the dates that you want in your dimension.

[JJ141]

Thank you so much! Its worked 🙂