I want to convert the data in int to minutes. How can I do that?
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.
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:
Hope this helps.
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.
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?
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.
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?
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.