Forum Discussion

android1's avatar
android1
Post Patron
10 years ago

Time difference in hours

Hi,   I'm trying to calculate the diiference in hours between two date/time columns. When I use DateDiff I am not able to use the two columns below.  
Need Help
Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

DATEDIFF(TablaHoras[TimeFrom];TablaHoras[TimeTo];HOUR)

  • android1's avatar
    android1
    Post Patron
    10 years ago

    Thanks for both answers. I'm getting the below error for both;

     

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      10 years ago

      DateDiff_Big...In PowerBI this function doesnt work.

       

      Your Measure should be look like this:

       

      MeasureName=DateDiff(xxxxxx,xxxxxx,Hour)

      • Sean's avatar
        Sean
        Community Champion
        10 years ago

        android1 You are creating a Column right? And the function is DATEDIFF