Forum Discussion
Ticket backlog
Dear Community, I have a very similar issue than this one that i've tried to resolve without the desired outcome. My scenario is very similar to the one described in this post: https://comm...
Hi Anonymous ,
What's the data type of your [Created] and [Resolved] column? Are they Date/time? Based on my test, if your link date/time column in fact table with date column in calendar table,it will show blank column:
But after I create a new date column by [Create] and link it to the calendar table, it works well.
_CreateDate = data[Created].[Date]If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Anonymous ,
Looking at the information you provide everything should work properly, only question I have is what happens to your matrix if you only have one of the measures?
Try debugging you data one step at a time:
- Add the columns ISSUEDID to your matrix and do a count that will make sure your relationship is working propely
- Add the Created measure and check if the result still checks
- Add the Resolved measure
- Finally add the last one.
Can you share some sample file?