Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
abodqm
Regular Visitor

using Datedif to see time differ between PM AM

hello guys i need help i have this begin and end time between pm and am 

and in datedif it shows negative i want it to calculate it right not show negative as shown below because time related to days as you know

abodqm_0-1707050261857.png

 

this is my code 

 

Differ between begin and end = DATEDIFF('Sheet1 (2)'[begin date],'Sheet1 (2)'[end date],MINUTE)
 
any suggestion how to make it read it right with with PM AM ???
 

 

1 ACCEPTED SOLUTION

7 REPLIES 7
Ahmedx
Super User
Super User

Share sample pbix file to help you.

how can i share the file with you 

you can upload it on 1 driver or google drive
or this

https://dropmefiles.com/

unfortunately I didnt understand how to share it 

Screenshot_1.png

 

pls try this

Screenshot_1.png

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors