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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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

 

 

 

mwegener
Most Valuable Professional
Most Valuable Professional

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 - Power BI Tutorials


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

mwegener
Most Valuable Professional
Most Valuable Professional

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 - Power BI Tutorials


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.

mwegener
Most Valuable Professional
Most Valuable Professional

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 - Power BI Tutorials


mwegener
Most Valuable Professional
Most Valuable Professional

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 - Power BI Tutorials


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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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