Forum Discussion

android1's avatar
android1
Icon for Post Patron rankPost 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
Icon for Community Champion rankCommunity Champion
10 years ago

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

android1's avatar
android1
Icon for Post Patron rankPost Patron
10 years ago

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

 

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity 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
      Icon for Community Champion rankCommunity Champion
      10 years ago

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

       

    • android1's avatar
      android1
      Icon for Post Patron rankPost Patron
      10 years ago

      I'm confused. When I type DateDiff( I don't get the TimeFrom or TimeTo columns for selection in the measure.

      If I use a calculated column I do but get the above error.

      • Vvelarde's avatar
        Vvelarde
        Icon for Community Champion rankCommunity Champion
        10 years ago

        android1 the error above is datediffBig function change to datediff