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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

How do I convert data in int value to minutes?

Hello all,

 

I want to convert the data in int to minutes. How can I do that?

 

ekran2.PNG

 

Values ​​in the places indicated in blue have an int data type. I want to convert the values ​​here in minutes. Thank you in advance for your help.

 

11 REPLIES 11
v-gizhi-msft
Community Support
Community Support

Hi,

 

Please try to create column like this:

Column =
VAR a = 'Table'[Kalan Zaman(Dakika)]
RETURN
    TIME ( ROUNDDOWN ( a / 60, 0 ), a - ROUNDDOWN ( a / 60, 0 ) * 60, 0 )

The result shows:

25.PNG

Hope this helps.

 

Best Regards,

Giotto

Anonymous
Not applicable

Hi @v-gizhi-msft,

 

Thank you for the help. But my problem has not been solved yet and I need to solve this problem quickly. I have to convert the integer data (indicated in red) in the table in minutes. The part indicated with blue color was created with dax query. Note: The data type of the Start Date field is datetime.

 

Ekran Alıntısı2.PNG

Hi,

 

Do you want to combine your date column and these three columns(after converted to time format)?

Could you please share an expected result as screenshots?

 

Best Regards,

Giotto

 

Anonymous
Not applicable

Hi @v-gizhi-msft ,

 

The desired result is to show the user how far the piece has progressed and how long the piece is left. The values ​​in the table are in integer data type (Date field is created with datetime and blue is specified with dax query) The aim is to convert the integer values ​​in minutes to give the user the number of minutes since the start of the track and how many minutes are left until the piece ends. Do you think combining the date column and the other 3 columns here is my purpose? It made sense to me.

 

Ekran Alıntısı2.PNG

 

 

 

Hi @Anonymous ,

 

can you show us an example of the desired result?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Anonymous
Not applicable

Hi @mwegener,

 

The desired result is to convert the integer values ​​here in minutes to show the end user how long the part lasts.

 

Ekran Alıntısı2.PNG

Hi @Anonymous ,

 

what unit does the integer values have?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Anonymous
Not applicable

Hi @mwegener ,

 

Sorry, I didn't understand what you mean by unit. 🙂 Values ​​in the database are of integer data type. I have to convert it in minutes.

Hi @Anonymous ,

 

and I didn't understand what you mean. 😁

 

There is an integer value, for example 60.
What does this 60 mean? Seconds? Minutes? Hours?
How should the 60 be displayed in its minute display?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Hi @Anonymous ,

 

take a look at this.

https://docs.microsoft.com/en-us/dax/time-function-dax

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Anonymous
Not applicable

Hi @mwegener,

 

Thank you for the help. But my problem has not been solved yet and I need to solve this problem quickly. I have to convert the integer data (indicated in red) in the table in minutes.

Ekran Alıntısı2.PNG

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.