Forum Discussion

dinesh_kumar_g's avatar
dinesh_kumar_g
Frequent Visitor
4 years ago

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 w...
General Comment
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

dinesh_kumar_g ,

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

dinesh_kumar_g's avatar
dinesh_kumar_g
Frequent Visitor
4 years ago

Hi amitchandak I need this dax function for based on ticket raised time

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, dinesh_kumar_g 

    If convenient, please provide sanitized sample data and expected result in excel.

     

    Best Regards,
    Community Support Team _ Eason