Forum Discussion

nyit's avatar
nyit
Regular Visitor
8 years ago
Solved

How do I calculate average Response Time only between work hours 8AM-4PM

I hope some one here can help me out, preferably in layman terms (i'm still new to the power bi). I've been asked by my boss to set up a little view of our Spiceworks helpdesk system (ticket status,...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi nyit,

     

    It seems that you have made a mistake on the comma after '8'.

     

     

    Please change the Comma in red to ';', this formula should work.

     

    In addition, when you have written a dax formula, you could copy your dax formula to this dax tool which could help you check if your formula has syntax error and format it.

     

    Hope this can help you!

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi nyit,

 

It seems that you have made a mistake on the comma after '8'.

 

 

Please change the Comma in red to ';', this formula should work.

 

In addition, when you have written a dax formula, you could copy your dax formula to this dax tool which could help you check if your formula has syntax error and format it.

 

Hope this can help you!

 

Best Regards,

Cherry

nyit's avatar
nyit
Regular Visitor
8 years ago

Hi v-piga-msft,

 

Sorry for the late answer.

Thank you, that worked and the dax formatter is really great to check for errors.

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi nyit,

     

    That's great! My pleasure.

     

    Best Regards,

    Cherry