Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculating difference between 2 date time columns

 

I have two columns in my table column A time report logged and column B time report sent. Both column are of the format.

11/01/2021 09:22:32am 

 

I want to be able to be able to work our the time take from report created to sent in a 3rd column

 

See sample date

 

https://www.dropbox.com/s/pwb1clof20s3q1i/Time_.pbix?dl=0 

  • Anonymous ,

    Create a new column in Dax

     

    column c =[column B] -[column A]

     

    or

     

    column C = datediff([column A],[column B], Minute)

1 Reply

  • Anonymous ,

    Create a new column in Dax

     

    column c =[column B] -[column A]

     

    or

     

    column C = datediff([column A],[column B], Minute)