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.
Dear All,
I need your help:
I want to calculate Delta Time between rows for each PackageCode based on Destination.
This code did not work. It gives me delta T 0 for some reason
Solved! Go to Solution.
@Anonymous , with Time or status change TS
Datediff(maxx(filter(Table,Query[Time] <earlier(Query[Time])),Query[Time]),Query[Time],second)
you may need
&& Query[source] = earlier(Query[source])
@Anonymous , with Time or status change TS
Datediff(maxx(filter(Table,Query[Time] <earlier(Query[Time])),Query[Time]),Query[Time],second)
you may need
&& Query[source] = earlier(Query[source])
@Anonymous
This is the DATEDIFF,
DATEDIFF(<start_date>, <end_date>, <interval>)
Your Start and End time are same,
= DATEDIFF(Query[Time], Query[Time], SECOND)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Oh, I got it now:)
But when I want to to make difference between time and next in the row time, then how can specify it in <start_date>, <end_date>?
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.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |