Forum

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!

Hi Petek, Select the visual, go to the Format tab > under the Visual options there's 'Trend line'. See image attached: Mynda

Hi Linlin, Apologies for the slow reply. You posted your question in the public Power Pivot forum, so I didn't see it right away. I've moved it to ...

Hi Pam, You can easily automate all of this with Power Query. Including the initial task of extracting the 40k rows of PA data. Then any new data o...

Hi Rodney, mon1 is considered a cell reference. e.g. if you CTRL+G and enter MON1, you'll be taken to column MON. Try changing mon1 to mon_1 and...