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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.