Forum Discussion
Pivot
Hi,
My table is a direct query from Google big query. In the table I have column that has energy readings, date-time and socket id amongst others.
I have created 3 columns based on the energy column, 1 is MAX energy, 2 MIN energy and 3 MAX-(Minus) MIN.
When I pivot MAX minus MIN it should be the total of the row difference and not what I am seeing in the total column.
I should see 27.91 and not 516
still hard to see exactly, but what if you wrap your function like:
SUMX(
VALUES( table [col] that is on rows),
[Measure]
)Hi,
Im still getting the same result.
I have a electric board that has 20 sockets, I need to work out the energy used within each hour period per socket. Individually for each socket the MAX - (minus) - MIN energy that I created works correctly. When I use MAX - MIN as a total of all sockets its basically bringing back a figure of 516 rather than 27.9. In my raw data there are instances where energy MIN is 0 and MAX 516.
in my pivot table the individual socket readings are correct but total is not the sum of all readings
for e.g.
1 2 3 4 5 6
0.12 0.0 0.03 0.14 0.00 0.07 = 0.36, however what Im seeing is 516