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

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.

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