Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ajdm2007 ,

 

Have you done any filtering on the calendar date column?

 

You referenced the calendar date column in the PREVIOUSMONTH function.

 

If not, the PREVIOUSMONTH function returns all dates in the previous month using the first date in the calendar date column as input. However, this returns the empty table.
This causes the card visual to return blank.


You can try adding the calendar date column to the slicer, select a date and see if the card visual changes.

 

Best Regards,

Dengliang Li

 

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

ajdm2007's avatar
ajdm2007
Icon for Helper III rankHelper III
2 years ago

Hello Anonymous ,

 

Thanks for your input! I do have filters enabled, and there's data in the ticket table as well.

 

I’m pretty sure the issue is with the calendar table, which is related to the tickets table (calendar - DATE field / tickets - DATEONLY field).

 

I’m not sure what I might be doing wrong or if there’s an issue with the table, but there are no filters applied to it.

 

Thank you for any other advise.

 

Have a good one,