Forum

Hi Aye, Please check your example file. The 'Expected Result' data bears no correlation to the PQ Upload or Original data. When you resubmit yo...

Hi Aye, Not really enough information, but I expect you'll have to write a DAX measure for this. Mynda

Hi Brian, You need to use a PivotTable to return the results you want to see in the chart. The Excel Table will always include suppliers that do or...

Hi Aye, The Power Query editor window only shows the first 999 records. This is only a preview of the data and allows Power Query to be more respon...

Hi Jan, I'm confused. The data you have pasted in above is the output of the query, so I'm not following the example you're describing. The sales r...

Hi Samantha, Can you please attached the photos again, or even better a sample Excel file with a few examples of the data you want to lookup. You n...

Hi Alan, Thanks for clarifying and providing a clearer example. You're having to jump through hoops because your data is not in a tabular format. F...

Hi, The cell references in the dynamic named range formulas are not absoulte. Charts require absolute ranges in the dynamic named range formulas. R...

Hi Nadia, Looks like the CF 'Applies to' range is being disrupted when the PivotTable changes shape. Not much you can do about this, it's just a "f...

Hi Alan, Thanks for sharing your sample data. You can do this with a PivotTable without the need to concatenate columns. See example attached. M...

Hi Jan, You can do this with Power Query but not Power Pivot because the data in the sales report will be aggregated into one row for a/c Code 1083...

Hi Nadia, You haven't tried to apply any conditional formatting to that file as I recommended and linked to above, so I'm not sure what you've trie...

Hi Lea, You can use Conditional Formatting to switch the formats for percentages without decimal places. See file attached. Mynda

Hi Lea, This is a super advanced formula that uses concepts typically only known and understood by the developers of Excel, namely broadcasting and...

Hi Nadia, I would use Conditional Formatting for PivotTables to apply the background colours so that it automatically updates with change to the Piv...