Forum Discussion
Ticket backlog
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 ,
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 v-deddai1-msft ,
Many thanks for your help. Indeed after posting here, i continued to troubleshoot and also with help of this community i was able to find that i had to use another date column and it worked like a charm.
Thanks everyone for your help!Hi. Can you please help me with the solution that helped you?. I need to build the backlog measure as you described.
