Creating average on month with blanks

Hi wolfjnh

Try

DISTINCTCOUNT('Date'[Monat mit Jahr])

in your formula

'SOC tickets'[Monat mit Jahr] only has the months in which there is data.  The 'Date' table has all of them.

Hi AlB,

thank you for your post. I think, I found the solution.

First of all, you are right. I have to use the Date-Dimension in this formula.

But I have also to consider two more things. The connection between the two tables has to be unidirectional and the date filter in my report needs to come from my date table as well.

I will look, if there are side effects to my other reports, but I think, that this is the solution. Simple, just as I thought :)

Regards,

wolfjnh