Last seen: Apr 16, 2025
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
Hi Josh, The very last lesson in the course is on Custom Data Types. I think this will be of use for your Proforma Template. From what you desc...
Hi Mohamed, The first rule of data is that it should be in a tabular layout, so the very first step you need to take is to unpivot Lists A and B. ...
Hi Darron, You can use the Power Query Salesforce Objects connector to connect directly to your database from Power Query in Excel or Power BI. ...
Hi Kevin, Your file didn't upload. After selecting the file, you need to click the 'start upload' button and then wait for the grey check mark befo...
Hi Tomas, You can use Power Query or PivotTables to pivot the data into columns for 1, 2 and 3. If you share an example file, we can show you ho...
Hi Eileen, Q1 - you could possibly use Power Query to filter out the data you don't need based on the date of entry into the form. Q2 - Try form...