Forum

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...

Go to the Sample Query and change the data type there. Mynda

Hi Jonathan, Welcome to our forum! This technique doesn't work in Excel, sorry. Mynda

Hi Tony, I'm no hardware expert, but this post has some discussion on specs for running Power BI, which will also apply to Power Query in Excel as ...