Forum

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

It returns blank in a card because the card has no row context for the 'Date'. i.e. it doesn't know what the date is that it should be based on. I...

Rename the columns before appending so they match and then Power Query will know they are the same.

That's ok. You can download the data to one Excel file and then connect to that file with Power Query from a separate file to bring the data into the ...

Hi Gosia, You can append them and any columns that don't match will be empty for one dataset and vice versa. Mynda

Power Query offers a more efficient method for loading data into Power Pivot. If you load data already present in your Excel workbook into the Power P...