Forum

How can you calculate a 'total' year on year? Year on Year can only be one year compared to another, not all years compared to... what period? Your...

So if you look at Query 1 (the original query) on the 'other computer' it shows the query results, it's only Query 2 that is returning the error? W...

Hi Adam, There isn't enough information for us to troubleshoot, but it looks like you're already going through the process of filling in the blanks...

Does the other computer have access to the file path the original query is referencing? And does the other computer have the same version of Excel and...

You lost me with the 'original data table' as I don't know whether this is in Access or PQ. You then mention an if statement, but again I don't know i...

There is no actual data in the 7.08 file, it only has budget data. However, it would be correct to have a column for actuals and a separate column for...

Hi Alison, I would create a separate table with your Type information that contains the Contract No., Customer No. and Type data. You could do this...

I should add, as mentioned in the Merge tutorial 3.04, a merge is similar to doing a VLOOKUP to bring data in from one table to another based on match...

You should always add calculated columns in Power Query if possible as it's more efficient than adding columns in Power Pivot. There wasn't any mer...

Hi Mardi, Glad you discovered the quick measures, but this won't get you very far before you need to learn how to write your own DAX formulas for c...

Hi Mardi, You can use the DIVIDE function to add measures to your Power Pivot model that takes Consumption Wh / Unique Users etc. i.e. =DIVIDE([...

Hi Alison, Instead of dividing by 365 x 12 in the 'Inserted Division' step you'd use another table that has the various phasing rules for each acco...

Hi Julie, All of this can be done with Power Query except step 9: Printer settings, but you should be able to record a macro for that. Note: Ste...

Hi Wen, No, I don't know what is causing it, sorry. Where is the data stored that you're getting with the query? i.e. what is the source and whe...

Hi Wen, It's difficult to say without seeing what you're trying to do. Please upload a sample file so we can see the data you're working with. Also...