Forum Discussion

Anonymous's avatar
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 Job Table if the value is not matching use the measure you calculated for all the visuals
Need Help

2 Replies

  • v-chenwuz-msft's avatar
    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.