Forum Discussion

PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
3 years ago
Solved

Finding difference in minutes between two date/time fields

If got a column that I'm trying to calculate the number of minutes between to date/time fields.  I've currently got  Time To Access = DATEDIFF('UniqueUsers'[First Access Time],'UniqueUsers'[Send Dat...
Need Help
  • grandtotal's avatar
    grandtotal
    3 years ago

    Make sure that both input columns are in datatime format.
    Then try to remove the .[Day] part:

    Time To Access = DATEDIFF('UniqueUsers'[First Access Time],'UniqueUsers'[Send Date],MINUTE)

     

grandtotal's avatar
grandtotal
Icon for Resolver III rankResolver III
3 years ago

Make sure that both input columns are in datatime format.
Then try to remove the .[Day] part:

Time To Access = DATEDIFF('UniqueUsers'[First Access Time],'UniqueUsers'[Send Date],MINUTE)

 

PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
3 years ago

That was it....just ahd to remove the .DAY  Thanks!  It's the little things.....