Hi,
I'm slowly getting up to speed with Power Pivot but keep running into things I just don't know how to do !! Would anyone know how I might complete the attached sheet in Power Pivot - I'm basically looking up a value from DATA to give an interpolated result D in DATA using a 'LOOKUP' table to find the interpolated answer - the calculation is shown in the highlighted area. Not sure even how to begin this in Power Pivot so any pointers much apprecaited - this is Excel 2016. Cheers.
I'm slowly getting up to speed with Power Pivot but keep running into things I just don't know how to do !! Would anyone know how I might complete the attached sheet in Power Pivot - I'm basically looking up a value from DATA to give an interpolated result D in DATA using a 'LOOKUP' table to find the interpolated answer - the calculation is shown in the highlighted area. Not sure even how to begin this in Power Pivot so any pointers much apprecaited - this is Excel 2016. Cheers.