Last seen: Feb 8, 2025
Hi Del, You can use the FILTER function or PivotTables to extract data. If you get stuck, please provide an example Excel file so we can help you ...
Hi Donnacha, That's a tricky one. In lesson 7.04 there is a lesson on lineage view, but this won't tell you what fields are in use, only how data is...
Hi Rennae, You shouldn't have to start again, but it's difficult to help you fix it without the file. Are you able to upload it here? Remove any sen...
Hi Bax, I would use the MySQL Database connector. This will allow you to have Power Query write the SQL for you and leverage query folding which pu...
Hi Rik, You can see the options for sorting PivotTables here. Mynda
Hi Sathish, Your file isn't attached. To attach it, select the file, click 'Upload', then wait for the grey check mark beside the file size before ...
Hi Ian, The DAX FILTER function's second argument must return a Boolean true or false value. This: Hours[End of Week] = [Start Date] Returns...
Wow, Inga! That is the biggest formula I've ever seen! First, if you ever find yourself writing a formula that's even 1/4 of that size, you should ...
Hi Chris, I usually write fiscal periods like this: FP2024_01 for April FP2024_02 for May and so on. Where FP stands for Fiscal Period. ...
Hi Sjaak, The BLOCKED and TIMEOUT errors should not be permanent. If you're still experiencing them, go to the Help tab and send feedback so Micros...
Hi Christopher, Glad my tutorial was helpful. If you wanted to get data from a different folder, you'd need a separate query for this, which you...
Hi Sohail, The REDUCE function here isn't being used as it was intended. It is supposed to be used with a LAMBDA that accumulates to a single value...
Hi Nick, You can use Power Query to clean this data. In the attached file (sheet 'Table1') I've loaded your data to Power Query and replaced the as...
Hi Ben, In my Advanced Formulas course, I teach how you can use HSTACK or VSTACK to return multiple functions. e.g.: =PIVOTBY(Table1[[#All],[Seg...
My pleasure, Mohamed