Last seen: Jun 29, 2026
Hi Cele, No, there's nothing like that in Power Query. You have to filter out the data based on criteria, but that removes entire rows, not just th...
Hi Julian, I never said you were lying, just that in my test it didn't add an apostrophe. I couldn't reproduce your result from a new query, even u...
Hi Linda, That sounds like the perfect job for Power Query. With Power Query you can get the data from your 3 source files and consolidate it into ...
Hi Ahmed, Connect them using different developers? Do you have a column in your source data that classifies each row by Developer? If so you can us...
Hi Vladimir, You need to write measures for these calculations. See the Power Pivot course session 9.02 for the Calculate function. Note: I reco...
Hi Mark, You can use the Excel.CurrentWorkbook function to do this. Create a blank query in your Excel file that contains the tables you want to...
Hi Jack, Great question! You need to create a second relationship between the Ship Date column and the Dates table. This relationship will be inact...
Hi Vladimir, You can use the Time Intelligence DAX functions to write a measure that compares the data (see the Power Pivot course for that), or yo...
Hi Julian, I tested Add Column to join a first and last name and set the data type as Text and it doesn't add an apostrophe. Power Query is adding ...
Hi Julian, My guess is so that the formula appears as text instead of a formula. If it entered =HYPERLINK(...) without the apostrophe it would be a...
Hi Jack, The data being analyzed only has dates up to 12/30/2012 so the dates table simply matches that. Mynda
Hi Julian, This isn't possible with Power Query for Excel. You can choose a Web URL data type in the Power BI model and in Power Pivot for Excel, a...
🙂 you're welcome!
Hi Holly, Thanks for sharing the data. It looks like the data is already partially summarised and pivoted and this is the cause of your problems. N...
Hi Cele, See session 7.01 of the Power Query course on using Parameter Tables. Another option is shown in session 7.06 but this requires opening Po...