Forum

Hi Tony, Please read this post on speeding up Power Query refresh times for tips on things to try before purchasing a new laptop. Mynda

Hi Lea, Presumably you're referring to Priority ERP (I'm guessing because you weren't clear and I've never heard of Priority, but a Google search s...

Hi Obonganwan, Welcome to our forum! Please provide your file, or at least screenshots that show your data tables, relationships, data category for...

Hi Amol, Unfortunately, your question isn't clear. What has the first and second column data got to do with your formula? You originally said: "...

Hi Michael, In Excel 2013 the function PRODUCTX does not exist. i.e. Excel 2013 doesn't recognise and and therefore doesn't know how to calculate t...

Hi Emmanuelle, Replace the measure 'Rolling SoY Entity Count new' with SoY Entity Count field. Your second question is still not clear. Please p...

Hi Amol, Welcome to our forum! Try this formula in cell D2 of your file, then copy down: =IF(COUNTIF($B$2:$B$21,"Not Match")=COUNTA($B$2:$B$21),...

Hi Aisha, Welcome to our forum! It's difficult to help without a mockup file. In future, please take a few minutes to create one and share it. F...

Hi Chris, See this tutorial on absolute referencing Table structured references, which explains the double square bracket technique like so: =CO...

Hi Shawn, You can't dynamically colour axis labels in charts. However, here are some ideas that you could use: Label events in charts Label m...

Hi Emmanuelle, Yes, but you haven't been clear on what that value represents e.g. is it YTD for the month selected in the Slicer, or the total for ...

Hi Casey, When you use INDEX you need to use it on both sides of the range operator e.g.: =INDEX(...) : INDEX(...) Or if the starting cell is...

Hi Justin, Slicers can only control a single table. If you want to control multiple reports, then you can create PivotTables from your Table source...

Hi Tyrell, Welcome to our forum! What other PivotTables are you trying to connect to? Where are they and what are they called? Note: only PivotT...

Hi Shawn, This problem existed in your original file shared on this forum, so I don't think it's related to any recent changes to names. It also is...