Forum Discussion
Ticket Raised time and Initiated Time Dax
Hi All,
I have one requirement. I have ticket raised time and ticket initiated time columns.
Ex: Ticket raised on time is 6:00 AM support team will Initiated that ticket time is 9:00 AM actual we need to show this staus is "yes" but in database it is showing no. Support team working hours 9: 00 AM to 6:00 PM.
How to show "yes" using the above timings. Could please suggest any DAX. Thanks in advance.
4 Replies
- amitchandak
Super User
if you are only worried about system time
if(timevalue(now()) >= time(9,0,0) && timevalue(now()) < (18,0,0) ,"Yes", "No" )
you can add conditions
Thanks for fast reply. I will try this.
Hi amitchandak I need this dax function for based on ticket raised time
- v-easonf-msft
Community Support
Hi, dinesh_kumar_g
If convenient, please provide sanitized sample data and expected result in excel.
Best Regards,
Community Support Team _ Eason
