Forum

Not sure, Tony as it's difficult to say without seeing the file. It does seem like something is wrong if it can process it in 10 minutes upon opening,...

When Power Query gets new data it also gets the original data again, so in effect it's replacing the data that you've formatted. Not sure why it's not...

Hi Michael, Just to be sure, the query should get the data from the external data workbook and load it directly to Power Pivot/the data model in th...

Hi Michael, A Pivot Chart not connected to a PivotTable because it's coming direct from Power Query or Power Pivot? If so, then you can record a ma...

Technically you should have a date dimension table and in that table you would have your financial year column. You can create this in Power Query or ...

Hi Karen, Welcome to our forum! It sounds like you need a new column in your data for the financial year that classifies each date into the corr...

Hi Claudine, I'm not sure there is because the PDF is effectively just a print out. You'd need to make the visuals big enough that there are no scr...

Hi Michele, Welcome to our forum! You can load the Data table to Power Query and then create two versions of the data, one that excludes DEV and...

Hi Jose, Welcome to our forum! This error is caused by a name being referred to in your query for specific table or column names that are no lon...

Great to hear, Mark

Hi Mark, It's difficult to say without seeing your file, but this post for regular PivotTables also applies to Power Pivot. Hope that helps. If you...

Because the values in column A are text, not proper date/time serial numbers. Mynda

Hi Austris, I'm not sure how you'd write a formula to do this, sorry. However, if you put your data in an Excel Table the formula e.g. =SUM(A1:E1) ...

Hi Amol, Thanks for clarifying. I think if your 'Final Result' column had just said 'Please verify' instead of 'How I can find out pure "Not Match"...

Hi Lea, I don't recommend converting dates to text because it renders them useless in formulas. Why don't you use a custom number format: yyyy-m...