Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Good afternoon!
I am looking to create a formula/measure to capture how much time is between each row/entry.
I have the AI_Start_Time and then AI_Norm_Time.
I need to make a formula that shows the difference in time between entry 1's AI_Norm_Time, and entry 2's AI_Start_Time
(ex: Time between 10/14/2023 6:35:54AM and 10/14/2023 6:46:36AM = 10 minutes and 42 seconds.)
| Entry Number | AI_Start_Time | AI_Norm_Time |
| 1 | 10/14/2023 6:35:52AM | 10/14/2023 6:35:54AM |
| 2 | 10/14/2023 6:46:36AM | 10/14/2023 6:46:38AM |
Solved! Go to Solution.
@nataliesmiy1357 - it's not clear how you want to present this, but I've attached a PBIX file with a solution.
It shows the time in DD:HH:MM:SS format
If this works for you please accept as the solution. It helps others with the same challenge.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new column.
OFFSET function (DAX) - DAX | Microsoft Learn
Difference in seconds CC =
VAR _normtime = Data[AI_Norm_Time]
VAR _nextrowstarttime =
MAXX (
OFFSET (
1,
Data,
ORDERBY ( Data[Entry Number], ASC ),
,
,
MATCHBY ( Data[Entry Number] )
),
Data[AI_Start_Time]
)
RETURN
DATEDIFF ( _normtime, _nextrowstarttime, SECOND )
@nataliesmiy1357 - Did either me or @Jihwan_Kim solve this for you?
Accepting the solution helps other people find the answers on this forum, so please do this or let us know what else you need.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new column.
OFFSET function (DAX) - DAX | Microsoft Learn
Difference in seconds CC =
VAR _normtime = Data[AI_Norm_Time]
VAR _nextrowstarttime =
MAXX (
OFFSET (
1,
Data,
ORDERBY ( Data[Entry Number], ASC ),
,
,
MATCHBY ( Data[Entry Number] )
),
Data[AI_Start_Time]
)
RETURN
DATEDIFF ( _normtime, _nextrowstarttime, SECOND )
@nataliesmiy1357 - it's not clear how you want to present this, but I've attached a PBIX file with a solution.
It shows the time in DD:HH:MM:SS format
If this works for you please accept as the solution. It helps others with the same challenge.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 61 | |
| 59 | |
| 42 | |
| 18 | |
| 15 |
| User | Count |
|---|---|
| 108 | |
| 100 | |
| 39 | |
| 29 | |
| 29 |