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