Forum Discussion
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,...
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
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
Resident Rockstar
Resident Rockstar