Thank you. I can only see it on my phone at the moment. the comment “I wouldn’t attempt such a thing without a star schema”. Does the measure he...
Thanks. I do require them at customer level as well
The Y on Y % age is correct in that it is taking the total of the negative movement column and dividing it by the total of the Revenue PY column. T...
This measure doesn't appear to calculate correctly Negative Movement:=SUMX(VALUES(Table1[Customer No.]),IF([Current Cust Movement]>0,0,[Current ...
Thank you. I’m not at my computer to check but won’t this will alter the customer %ages as well? to have this calculation in addition to what we ...
Yes Query 1 works on the other computer and shows the query results it's only Query 2 that is returning the error. I created a Query 3 again refere...
Thank you. I'd rather not do it in Access if I can do it in one process in Power Query I've tried doing a 2nd merge with the update type table bu...
Based on the data in the file. If we take year 2018 for example The Total negative movement is -1,217 The Total revenue PY is 7,152 The nega...
Thanks but this doesn't appear to do the Access part. The ContractUpdate table includes all the contracts that do not have a Type referenced in the ...
The column total for Negative Y on Y% doesn't appear to calculate correctly/. Do I need another measure to calculate the total ie total negative mo...
They are in the same folder and both use office 365.
The original data source = the original file I sent. This I put in access and linked it to the table “ContractUpdate”. The join was on contract no a...
I was referring to where you had the Actual and Budget figures in their own columns. Would you unpivot these before sending to power pivot?