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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
joel121960
Helper I
Helper I

convertir formato epoch time a formato Hora.

mi data se muestra en este formato necesito cambiar a hora. 

joel121960_0-1727738193631.png

 

1 ACCEPTED SOLUTION

Hi, @joel121960 

Thank you for your reply. If you need to convert numbers to HH:MM:SS, you can refer to the following article and demonstration by Super user, who has a detailed DAX expression for this:

Chelsie Eiden's Duration - Microsoft Fabric Community

vjianpengmsft_0-1728011109724.png

The original data and results demonstrated by Super user are consistent with yours. You can find the answer in his article.

 

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
v-jianpeng-msft
Community Support
Community Support

Thank you Ritaf1983 

Hi, @joel121960 

Your screenshot shows a column of numbers, and if you need to convert it to time, you can refer to the following article:

6 Ways to Convert Numbers to Dates in Power BI - Power Tech Tips

vjianpengmsft_0-1727765128899.png

If you want to convert these numbers to HH:MM:SS format, you can refer to the following article:

Solved: Convert a number to 24 Hour time - Microsoft Fabric Community

vjianpengmsft_1-1727765685584.png

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hola @v-jianhe-msft   me podrias ayudar a convertir en el formato en rojo. 

joel121960_0-1727817035209.png

 

Hi, @joel121960 

Thank you for your reply. If you need to convert numbers to HH:MM:SS, you can refer to the following article and demonstration by Super user, who has a detailed DAX expression for this:

Chelsie Eiden's Duration - Microsoft Fabric Community

vjianpengmsft_0-1728011109724.png

The original data and results demonstrated by Super user are consistent with yours. You can find the answer in his article.

 

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Ritaf1983
Super User
Super User

Hi @joel121960 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.