Forum Discussion
Problem Calculating Date Diff from Date formatted DD/MM/YYYY HH:MM
Hi Everyone, i have a problem that i just cant seem to solve and im certain there is a simple alternative out there. I have a column (Example below) that has a cell formatted DD/MM/YYYY Hours:Minutes...
Hi Mark,
Data example and output below, i have achieved it on Excel with the following but struggling with the Power BI query. i basically want to compare the Target Completion Date with TODAY() or NOW() to get an output in a format below
=INT(J2-NOW())&" Days "&HOUR(MOD(J2-$N$1,1))&" Hours "&MINUTE(MOD(J2-$N$1,1))&" minutes "
Target Completion Date Target Completion Date in days
21/02/2023 08:15 -1 Days 15 Hours 16 minutes
21/02/2023 09:04 -1 Days 16 Hours 6 minutes
21/02/2023 07:54 -1 Days 14 Hours 56 minutes
21/02/2023 15:07 -1 Days 22 Hours 9 minutes