Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
User | Count |
---|---|
16 | |
13 | |
13 | |
12 | |
11 |
User | Count |
---|---|
19 | |
16 | |
15 | |
11 | |
9 |