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_Big...In PowerBI this function doesnt work.

 

Your Measure should be look like this:

 

MeasureName=DateDiff(xxxxxx,xxxxxx,Hour)

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

       

       

       

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

        Hi android1,

         

        From the image, the custom column DAX expression is correct. And I havn't seen the table visual displays the error you mentioned. Would you mind sharing the .pbix file for us to analyze closely?

         

        Best regrdas,
        Qiuyun Yu