Forum

Hi GK, Welcome to our forum! If you want the action performed at the file level before appending the files together you make the transformations...

Hi Marc, Please see file attached. I added your data to Power Pivot and added 3 DAX measures to sum the averages. Hope that helps. If you'd like...

Hi Azid, VBA is the tool for automating Office tools. That said, VBA is not executable on the web, so longer term it would serve you better to lear...

Hi Pawel, Welcome to our forum! It is not advisable to manually add a column of data to the query output table for the reasons you have found. I...

Hi Marc, No file attached, however this behaviour is by design. You need to use Power Pivot and write a DAX measure to modify how averages normally...

ok, if you say so. I can't test at my end because I have different date settings to you, hence my alternate formula 🙂

Yes, it's a compromise you have to accept, unfortunately. Mynda

Sure, happy for you to share an external link. Nice solution!

Hi Jomili, Sorry for the delayed reply and thanks for sharing your file. Whoever opened the file in Excel originally has messed up the dates. This ...

Hi Alistair, Sounds like you might have provided a path that's to your SharePoint/OneDrive file location? Or maybe the path isn't formatted correct...

Hi Oana, You just need to unprotect the Pivot Charts that have the expand/collapse functionality and then check the box 'use PivotTables and PivotC...

Hi Arun, Thanks for clarifying. Some of these calculations are not designed to be performed in a table that contains different symbols. If you look...

Hi Oana, Welcome to our forum! Unfortunately, we can't change the alignment of the axis labels, so all you can do is as Jessica suggested, make the...

Oh, those are default values that get included in your filters/slicers when you group dates. If you have Excel 2016 or later you can go into the Slice...

Hi Arun, No file uploaded. Please click the 'start upload' button after selecting your file and then wait for the message in green below the attac...