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
Anonymous
Not applicable

Time field can not be summed in powerBI

Dear All,

My issue is what i can not solve, i have a time column in Excel in the format [h]:mm showing the duration of the call. It perfectly works in excel in Pivot table is can easily sum up them by period. Scrrenshot attached.

ghunderassi_0-1673367711850.png

However in Power BI after import, the field appears in this very strange format :

ghunderassi_2-1673368069800.png

and powerBI simpli can not handle it as a number. Can anyone please lighten me up, what i try not correctly? 

I already tried to add different kind of fields like 

IRTime = SUMX('2022',HOUR('2022'[Incident Resolution Time])*3600+MINUTE('2022'[Incident Resolution Time])*60)
 
or 
IncidentResolutionTime =
VAR _Hour = HOUR( SELECTEDVALUE( '2022'[Incident Resolution Time] ) )
VAR _Minute = DIVIDE(MINUTE( SELECTEDVALUE( '2022'[Incident Resolution Time] ) ), 60, 0 )
VAR _Result = _Hour + _Minute
RETURN
_Result
 
But didnt help.

 

5 REPLIES 5
Anonymous
Not applicable

Hi Ibendlin!

Thank you for the response. I created a sample data both in excel and in powerbi, but this field not supports nor xlsx nor .pbi files. Can you please advise how could i upload them here?

Thank you,

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

Anonymous
Not applicable

Thanks a lot Ibendlin for your fast response. i tried this already but duration type is greyed out unfortunately. I dont understand why either. 

ghunderassi_0-1673516822341.png

 

Do the type conversion in Power Query, not in Power BI.

 

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

lbendlin
Super User
Super User

Use the Duration type instead.

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.