How do I convert data in int value to minutes?

[Anonymous]

Hello all,

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.

[v-gizhi-msft]

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:

Hope this helps.

Best Regards,

Giotto

[Anonymous]

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.

[v-gizhi-msft]

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]

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.

[mwegener]

Hi @Anonymous ,

can you show us an example of the desired result?

[Anonymous]

Hi @mwegener,

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

[mwegener]

Hi @Anonymous ,

what unit does the integer values have?

[Anonymous]

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]

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?

[mwegener]

Hi @Anonymous ,

take a look at this.

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

[Anonymous]

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.