Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
New to Power Bi, bought myself a nice book to help but this is locked in my office and I am not currently able to get there so working blind with it. So far so good (even if I do say so myself).
Have a problem with multiplying a number against a set constant time. I am using the following:
Account Review Time = Hour([Accounts Checked]*(time(0,03,0)))+trunc(minute([Accounts Checked]*time(0,03,0))/60)&":"&mod(MINUTE([Accounts Checked]*time(0,03,0)),60)&":00"
This returns me a value of 0:42:00
Does the same in excel so I know the maths is correct but in excel I can change the format of the cell to [hh]:mm:ss and that gives me hours over 24. For reference, by coincidence the number of hours is a multiple of 24.
Any help much appreciated.
Hi @DLROLLINGS
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.
Refer if this can help
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
Thanks for this, trying to apply this to my formula but unsuccesfully.....very confused 😕
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |