Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all.
I'm trying to get out the total number of minutes from "Sluttid" and "Starttid" and find how many minutes differs the two.
However Durations don't seem to work like you can see below and I wonder why... and what I can do about it!
Solved! Go to Solution.
@filip_u_s I think your two columns are Time columns and not Duration columns so you will need to convert them to Duration columns first. Or use Time.Minute instead.
Good day filip_u_s,
Table.AddColumn(#"Filtrerade rader1", "Mintid", each Duration.TotalMinutes([Sluttid]-[Starttid]), Int64.Type)
gives,
This should work provided Sluttid is greater than Starttid.
Hope this helps.
Good day filip_u_s,
Table.AddColumn(#"Filtrerade rader1", "Mintid", each Duration.TotalMinutes([Sluttid]-[Starttid]), Int64.Type)
gives,
This should work provided Sluttid is greater than Starttid.
Hope this helps.
wow, thanks collinsg... that really did the trick and so easily!
@filip_u_s I think your two columns are Time columns and not Duration columns so you will need to convert them to Duration columns first. Or use Time.Minute instead.
Thank you Greg... you were so right... shame there is no time.totalminutes... but now I can keep building my report 🙂