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.
I have a column with negative and positive numbers. I use the formula below but when comparing the output to a 'manual' check of the column, the outputs are different.
JobToAttAccepElapsedTime:=CALCULATE(SUM(FF_August_Dataset[JOB_TO_ATT_ACCEP_ELAPSED_TIME]),FF_August_Dataset[JOB_TO_ATT_ACCEP_ELAPSED_TIME]>0)
Formula output = 57,353
Manual check = 58,221
Here is link to sample data. Formula above is referencing column D (difference between dates in column C&B) in sample data file below. Note: column D was imported to data model and changed values to whole numbers format to represent HOURS
Appreciate any help.
So are you saying that, for example, line five that has 97:09:01 in Column D is changed to 97 somewhere along the line?
Yes that is correct
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |