Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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,
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 @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,
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
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 @Anonymous ,
can you show us an example of the desired result?
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
Hi @mwegener,
The desired result is to convert the integer values here in minutes to show the end user how long the part lasts.
Hi @Anonymous ,
what unit does the integer values have?
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
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?
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
Hi @Anonymous ,
take a look at this.
https://docs.microsoft.com/en-us/dax/time-function-dax
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
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
111 | |
59 | |
57 |