This is the second thread I am posting regarding problems with un-pivotting. Sorry, I’m still just not getting it. I have three “Leave” columns which I need to unpivot as shown by (1) below. But when I do unpivot, my numbers for NORMAL HOURS and NIGHT HOURS are thrown out because of the duplication, see (2) below.
I feel especially stupid here. Could someone please (once again) step me through how to fix this?
Q.07 Data.xlsx (64.9 KB)
Q07. Unpivot (one) group of columns, how to fix duplication (I now have incorrect totals).pbix (43.4 KB)
As always, thank you.