Forum

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

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...