Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have 2 columns that contains DD/MM/YYYY HH:MM:SS values and I need to work out the [H]:MM:SSS difference.... The columns are named [Time] & [Alarm Time] and [Alarm Time] will always be greater than [Time]
For example, if [Time] was 01/01/2023 00:00:00 and [Alarm Time] 03/01/2023 00:00:00 - this would need to be 48:00:00 rather than 2 days.
Any suggestions on how I can create this succesfully would be greatly apperciated.
Hi @alexw94
You can do something like:
= Table.AddColumn(#"YourPreviousStepName", "Diff", each Duration.Days([Alarm Time]-[Time])*24+ Duration.Hours([Alarm Time]-[Time])+Duration.Minutes([Alarm Time]-[Time])/60+Duration.Seconds([Alarm Time]-[Time])/3600)
@mlsx4 - Thank you for your reply. The "YourPreviousStepName" bit confuses me. The previous step in my applied steps was adding a custom column thats irrelevant to these 2 columns. I did type out the name of that previous step in that but "Added Custom 1" and i get the error saysing "Make sure the previous step is spelt correctly".
Hi @alexw94
You need to include the previous step name just because M follows an order... Anyway, if it isn't clear for you, you can add a custom column and add only this part:
Duration.Days([Alarm Time]-[Time])*24+ Duration.Hours([Alarm Time]-[Time])+Duration.Minutes([Alarm Time]-[Time])/60+Duration.Seconds([Alarm Time]-[Time])/3600)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.