Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
My company have to respond to a service request by a certain date and time (RespondBy). Please could you let me know how I can create a column to compare the date and time we actually responded to the request (RespondActual) to RespondBy.
If RespondActual <= RespondBy we get an SLA pass, otherwise it's a fail.
RESPONDBY | RESPONDACTUAL |
25/06/2020 20:46 | 25/06/2020 18:46 |
25/06/2020 20:46 | 25/06/2020 21:46 |
Many thanks,
Marcus
are you only interested in showing that flag on the individual event level, or is there an expectation for some sort of Totals?
Many thanks for your super quick response. I'm just looking to record pass or fail as individual events first off. I'll then do a count before displaying on a pass/fail visual.
in that case it is as simple as
Pass = (SELECTEDVALUE(RespondActual) <= SELECTEDVALUE(RespondBy))
for a measure or
Pass = RespondActual <= RespondBy
for a calculated column (which would be more appropriate in your scenario)
Hi, many thanks but it hasn't worked out as expected. Probably down to me. I'm not worried about the blank cells, I'm sometimes getting False when it should be true. for example with WONUM 1071803. ACTSTART was an earlier datetime than RESPONDBY.
Many thanks,
Many thanks for your response Daxer.
It looks from the below that the format is datetimes but I might well be wrong! Does this look right to you? Thanks again
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
19 | |
16 | |
16 | |
16 |
User | Count |
---|---|
51 | |
23 | |
20 | |
17 | |
16 |