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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
saikiran
Helper I
Helper I

i need Time format.

Hi all,

 

  i have one dataset in those dataset i have users and start time and end time and duration by using these three fields i created report and i calculated  total hours by using duration field for this i used calculated measure :Sum(table[duration]) by default i am getting date format 13/12/1899 and i am changed these calculated measure format as time(i.e., hh:nn:ss) then after it is shown only hours.then after same report (pbix file)i am sending to my client they are getting again Date format(i.e.,13/12/1899).

same report i am send to my colleauge but he is getting correct format and my client is located in australia but they are getting date format.please once see below screen shots and help me as soon as possible.

 

 

Thanks in advance!!My client is receiving like thisMy client is receiving like thisi am created like thisi am created like this 

1 REPLY 1
Greg_Deckler
Super User
Super User

See if this helps:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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