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

I have one very stupid question, 

 

when I'm using code like this:

and then this:

it works, but it does not work when I'm using this code:

Can anyone tell me, what's wrong with second code?

 

 

thanks 🙂

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

    I understand reason 🙂

     

     

     

    thanks anyway