Forum

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

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