Forum Discussion
Calculating value differences for each week
I have some 'availability' numbers (a percentage) for a bunch of machines on a weekly basis. My raw CSV data looks like this: Machine,WW,Availability
A,WW35,0.9
B,WW35,0.95
C,WW35,1
D,WW35,0....
Hi Anonymous - this might be better off doing a PowerQuery/M creation of columns showing this week's Pass/Fail and Last Week's Pass/Fail. May want to post in that forum.
ImkeF
vanessafvg
tex628
mahoneypat
edhans
David