Forum

Hi David, Welcome to our forum! No silly questions here 🙂 You can use the COUNTIF function to count how many tasks are completed, which can th...

Hi Cynthia, I don't think IRR is correct to use in this case because there is no 'return' as such. NPV makes more sense. i.e. what's the net presen...

Hi Chris, Are you able to share your file or a sample file that illustrates the issue? It's difficult to troubleshoot without seeing the data. M...

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