Forum

Hi and welcome to our forum! It's always best if you can attach an Excel file so we can give you a file back with a completed solution as we don't ...

Hi Frank, Welcome to our forum! Is the data type in the query set to Date? Mynda

Hi Lee, Welcome to our forum! I'm not able to recreate this problem. I wonder if the data you're adding is text rather than numbers. Are you abl...

Hi Bax, The problem can be fixed by first adding an index column before pivoting. However, that will give you a stepped result, which I doubt you w...

Hi Chris, When you say 'change the date column in the Power Pivot data model to display only the date part' do you mean with the formatting? Hav...

The second table with the comments should not be connected to a query. It should simply be a list of the ID numbers and your comments which you then i...

Hi Jennifer, You haven't said why you're unable to create the relationship, but I'd say it's giving you a duplicates error. If so, you need to crea...

Hi Stevie, Welcome to our forum! You can use Power Query to exclude a list of items from a list as explained here. Mynda

Hi Chris, Welcome to our forum! In Power Pivot you can set the number format for a field in the Power Pivot model on the Home tab of the ribbon....

Hi Tim, Combine the files from a folder twice, once for the headers and once for the data. Transformations will have to be done in the sample files...

Hi Michael, I use the OneDrive sync tool to also store a copy of my SharePoint/OneDrive files on my hard drive. It automatically syncs them with th...

Hi Bax, Instead of putting your comments field in the Power Query table, or any table for that matter. Put it in a column beside the table, then de...

Hi Paul, In an update to Excel you can no longer have the workbook open. You need to close the source file and get the data from a new blank workbo...

Hmmm, that's not usually a requirement when you get files from a folder.

Hi Tim, Please see example file attached. Hope that points you in the right direction. Mynda