Forum

If you're using the query in another sheet in the same workbook then you don't need to duplicate the data again because the query should be able to fi...

Hi Trevor, There's no incremental refresh in Power Query for Excel yet. It's in preview in Power BI's version of Power Query, so it's coming. We ju...

Hi Jan, Your first question is definitely a measure, in fact you should calculate measures for the sum of costs and a separate one for the number o...

Hi Sanal, Can you please let me know which session number you're referring to for the practice file? In regards to copying the workbook into the...

Hi Kenneth, Please find an example attached. Hopefully you can follow the 'Applied Steps'. There is some similarities in this post on numbering gro...

Hi Lisa, Technically the calculation is correct, however I understand the issue is more to do with whether the line is revenue or expense. As an ac...

Hi Jordan, Welcome to our forum! It sounds like you're pasting the query into a new workbook or one that doesn't contain the table called 'SrcBa...

Hi Sheikh, Welcome to our forum. That's a tough one. I can see there are two extra characters at the front of the text but I couldn't remove them u...

Hi Brian, If you select a value cell, then click on the filter drop down in the row labels cell > More Sort Options... this opens a dialog box w...

Hi Miguel, I wonder if it's a regional setting to do with decimal places. You could try right-clicking the column > change type > using local...

Hi Brian, Welcome to our forum! In Worksheet Protection (Review tab > Protect Sheet) you can check the box to allow users to 'Use PivotTable ...

Hi Paulo, It seems odd that the user would even go near the query, let alone change the name of it. The query name is also the table name in Power ...

Hi Josh, You can use this formula to work back from the Final Premium in the E&S Liability example: =20127.70/(1+0.1%+5%)-250-35 This for...

Hi Steve, Great questions. Answers below: 1. That's just the way it is. Once the editor window is open you can't even work in the Excel workshee...

Hi Chris, You can extract the questions and number them in a separate query before merging them back to the original query where you do the rest of...