Forum Discussion

Anonymous

Not applicable

4 years ago

undefined

Create a Measure to calculate the "Job Duration" from the Job table, Job Duration is the difference of Job start time & job end time . Compare this calculated value with job real duration column in Jo...

Need Help

v-chenwuz-msft

Community Support

4 years ago

Hi Anonymous ,

measure =
VAR _start =
    SELECTEDVALUE( 'table'[start time] )
VAR _end =
    SELECTEDVALUE( 'table'[end time] )
VAR _duration = _end - _start
RETURN
    IF( _duration = SELECTEDVALUE( 'table'[real] ), TRUE(), FALSE() )

Please share some sample data if you need more help.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.