Forum Discussion

odzelashvili1's avatar
odzelashvili1
Icon for Helper I rankHelper I
5 years ago
Solved

Time difference measure by one column

Hello PBI community 🙂   My table has this view:   I want to see what is difference between VISIT_CREATE and VISIT_END.   For this task, I'm using DATEDIFF function, which really works: ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    odzelashvili1 , Try a measure like

     

    AverageX(Values(MainTable[Visit ID]), [WD_create_to_end])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

odzelashvili1 , Try a measure like

 

AverageX(Values(MainTable[Visit ID]), [WD_create_to_end])

odzelashvili1's avatar
odzelashvili1
Icon for Helper I rankHelper I
5 years ago

Thank you very much 🙂 it works!

 

Can you explane what really does this measure? I dont want to copy+paste, I want to understand how it works 🙂 Thanks again