Forum

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

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