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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.