i need Time format.

saikiran — Thu, 16 Apr 2020 07:51:37 GMT

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 thisi am created like this

Re: i need Time format.

Greg_Deckler — Thu, 16 Apr 2020 13:15:45 GMT

See if this helps:

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

topic Re: i need Time format. in Developer

i need Time format.

Re: i need Time format.