Forum

Hi and welcome to our forum! The IF, SUMIFS etc. are what's making your file slow. You're better off using Power Query to get your source data in o...

How about using FILTER: =MIN(FILTER(DataTable[Retail_Price],(DataTable[Product]=[@ProductResult])*(DataTable[Colour]=[@ColourResult])*(DataTable[We...

Hi Pierre-Stephane, I'm not sure why it wouldn't be displaying the correct columns. Can you please send a screenshot of what you see in the Custom ...

Hi Khunsu, Welcome to our forum! Please see my introduction to Power Query video where I demonstrate a few uses for it. Hope that gives you some in...

Hi Luca, Yes, you can use 'Show Values As' to calculate the difference. Let me know if you get stuck after reviewing the tutorial linked to. Myn...

Hi Zaki, Select the timeline slicer > CTRL+1 to open the formatting > Properties > deselect 'locked'. Go to Review tab of ribbon > Prot...

Hi Leon, Welcome to our forum! This would have been done with VBA. If you're able to share the file and post your question in our VBA forum I'm ...

Hi Ian, Welcome to our forum! You can use the Clear Filters button on the Data tab of the ribbon. I've even added this icon to my Quick Access T...

Hi Chloe, Welcome to our forum. I presume you're talking about Power Query and not the old Microsoft Query? If so, you can use this http error h...

Hi Tom, You can certainly to this with Power Query. See the queries in the example file attached with the 'Append1' query showing the final result....

Hi Richard, This post has some tips on improving query performance. Hope that helps. Mynda

Hi Mitryaeva, I would have your SQL database administrator create a "view" of the tables you want to bring into Power Query, rather than having Pow...

I can't replicate this issue. When I enter that formula it returns 61,77164

Hi Barry, Welcome to our forum! I'm glad you found my tutorial helpful. I'm not familiar with Microsoft's pricing models, but I did a Google search...

Hi Tracey, I can't see anything wrong with what you've done. If you add the Budget Balance measure to your PivotTable in column A of the BudgetByEx...