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.

Hi Anonymous , take a look at this. https://docs.microsoft.com/en-us/dax/time-function-dax

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

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.

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.

Hi Anonymous , can you show us an example of the desired result?

How do I convert data in int value to minutes?

11 Replies

mwegener
Most Valuable Professional
6 years ago
Hi Anonymous ,

take a look at this.

https://docs.microsoft.com/en-us/dax/time-function-dax
- Anonymous
  Not applicable
  6 years ago
  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.
v-gizhi-msft
Community Support
6 years ago
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
  Not applicable
  6 years ago
  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.
  - mwegener
    Most Valuable Professional
    6 years ago
    Hi Anonymous ,
    
    can you show us an example of the desired result?