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
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

     

  • android1's avatar
    android1
    Post 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
      Community Champion
      10 years ago

      android1 the error above is datediffBig function change to datediff

    • Sean's avatar
      Sean
      Community Champion
      10 years ago

      android1 You have to create a COLUMN - NOT a Measure!

       

      Look at the picture in my post above - you can't do this as a Measure - that's why the columns are not showing up when you type!

       

      click New Column - then you'll see the columns will show up after you type DATEDIFF

       

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      10 years ago

      Hi android1,

       

      In your scenario, please take a look at Sean's first reply. You need to create a calculated column instead of measure by clicking "New Column" button. As you mentioned the error occurs when you create a calculated column, would you please share a screenshot about the DAX expression for this column? And which visual do you use to display this calculated column values?

       

      Best Regards,
      Qiuyun Yu

      • android1's avatar
        android1
        Post Patron
        10 years ago

        Hi Qiuyun_Yu,

        I am using a Table visualisation. Here is the custom column  ->