Forum

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

The FORMAT function can take multiple formats. The first format is for positive values and if no other formats are provided, it will apply this to all...

Hi David, Apologies for missing your follow-up question on YouTube. I get so many comments, I can't attend to them all. When building the form, ...

Hi Hanan, I wouldn't worry about having too many rows. Power Pivot can handle 100s of millions of rows of data if required. See example file att...

Hi Vicki, Thanks for following up, however in future when you cross post you should declare that up front so volunteers know that they could be was...

Great to hear!