Forum Discussion
How do I calculate average Response Time only between work hours 8AM-4PM
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
Resident RockstarHi nyit,
You could create the calculated column with the formula below.
Column =
IF (
AND (
HOUR ( 'table'[Created_at _hour] ) >= 8,
HOUR ( 'table'[Created_at _hour] ) < 16
),
'table'[Created_at _hour],
BLANK ()
)
Then you will get your expected output.
For reference, you could have a look at my test pbix file attached below.
Best Regards,
Cherry
Hi v-piga-msft,
thank you for your reply
but apparently i'm not doing it right, so i don't know if it works.
perhaps you could help me out once more?
- v-piga-msft
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