Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hello
i would to ask how can i calculate minutes between two times.
here i try:
Solved! Go to Solution.
Hi @Raoom_A
I'm unsure why you think your original measure didn't work.
Also, I'm unsure of how you can expect a result for the first 2 rows to both be equal to 10 minutes.
Out of curiosity, are your dates formatted as MM/DD/YYYY or DD/MM/YYYY ? That would make a big difference.
Hi @Raoom_A
I'm unsure why you think your original measure didn't work.
Also, I'm unsure of how you can expect a result for the first 2 rows to both be equal to 10 minutes.
Out of curiosity, are your dates formatted as MM/DD/YYYY or DD/MM/YYYY ? That would make a big difference.
It is correct that I made a mistake in writing the date .. Thank you!
Please try this expression.
= 24*60 - ('Table 1 (page)'[open] - INT('Table 1 (page)'[open]) - 'Table 1 (page)'[close] + INT('Table 1 (page)'[close]) )
sorry it dose not work!
the result it pic
@Raoom_A Try this:
Column = ([open] - TRUNC([open])) - ( [close] - TRUNC([close])) * 24 * 60
do not work
Did not bring the expected output
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
73 | |
71 | |
69 | |
46 | |
44 |
User | Count |
---|---|
46 | |
38 | |
28 | |
28 | |
28 |