Forum Discussion

wolfjnh's avatar
wolfjnh
Frequent Visitor
7 years ago
Solved

Creating average on month with blanks

Hi,   I have a small problem, which lifts me to my edge.   I have two tables:   Dates - typical date dimension with one row per day SOC Tickets - tickets from our bug tracking tool with differ...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    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.

  • wolfjnh's avatar
    wolfjnh
    7 years ago

    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

wolfjnh's avatar
wolfjnh
Frequent Visitor
7 years ago

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

AlB's avatar
AlB
Community Champion
7 years ago

wolfjnh

Correct on both.  I had not seen you had a bidirectional relationship

Best