Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

MoM% Returning (Blank)

I have several quick measures that are returning (Blank) Values. I'm using a date table marked date table.  The simplest is here. COMs_20200604[Number] refers to the individual case number.      Me...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    The DATEADD function requires contiguous date selections ,so make sure your date table have contiguous date. If not, you may create a calendar table using DAX below. Then create relationship between your fact table and the calendar table with Both of Cross filter direction .

     

    Calendar =CALENDARAUTO()

     

    You may put [Month] and [Total Cases MoM%] into table visual to display the result.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

Anonymous 

Can you try add the month filter and select a month to see if this works?

 

I think you didn't identify the month, the card shows total value, then can't show the pervious month value.