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.
good morning to everybody i hope you guys are having a good day, so im using an formula to deliver me the result of time worked in hours, the result is greater than 24h so i needed to use the text method, but the point is the results are differing from 3 hours to 9 hours, i needed to divide it into 3 pieces to obtain the result and these are the formulas i used
i want to know if there's a way to put these 3 together and how can i correct the result since i already checked the original dataset and the data is correct, i've had already used this formula before and everything went well but this time it is giving wrong results.
since now thanks for your help and time !!
Hi @MachisukiJ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
hi @v-shex-msft thanks for your reply
i unfortunatelly cannot provide the data, but i can provide some examples about the result and type of data that i use, the raw data comes at duration format that i turn into seconds to turn into hours greater than 24h, for an example at the week 14 the result should be 265h but with the formula it came out as 261h, so i want to know if there's a way to correct that result but without needing to change the data
HI @MachisukiJ,
Can you please share these dummy data and paste here with table format, then we can simply copy it to power bi and use it to test to coding formula. (it is hard to test without any sample data)
Regards,
Xiaoxin Sheng
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 |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |