Forum

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

Hi Liam, Thanks for sharing your file. If you add decimal places to the number formats in row 5, you will see that M4, M5 and M6 all contain values...

Hi Bax, You can't change the format of date fields in the Pivot Chart. Your options are: 1. Group the data by month and year in the PivotTable a...

Hi Danielle, Please share a small sample file with the desired result and your measure returning the incorrect result. Mynda

Hi Mohamed, 100% yes, Power Query can automate the laborious copying and pasting processes, as well as other typical data gathering and cleaning ta...

Hi Gregory, This post explains how the database functions like DSUM work. You can link your combo boxes to the filter cells referenced in your DSUM...