Forum

Hi Babacar, I wonder if the column you're working with contains a dollar sign or similar currency symbol? If so, try replacing that with nothing an...

Hi Marianne, I wonder if something is corrupt in your second workbook as a result of copying it, as opposed to starting from scratch. Are you ab...

Hi Chris, Great to see you're giving Power Query a go to clean up your data. You can select multiple columns in Power Query in the same way you ...

Hi Walt, Correct, the lesson name is just a header or wrapper. The videos are held at the topic level which you see when you click on the 'Expand A...

Right-click a cell containing the values you want to display as a running total > Show Values As > Running Total In... > Base Field: Lease D...

Can you please share a sample of the file which contains the source data with the dates we can see in the screenshot you shared. It looks like it migh...

Thanks, Chad. I've shared with Microsoft, but your results confirm that it's ACE that's the issue. Remember, the preferred method for getting data ...

Hi Chad, Please test Access before using the patch Catalin suggests so that we can compare like for like. Thanks, Mynda

Hi Sreedevi, I'm not aware of a hard limit on the number of tables, but I'm concerned that you want to break up fact tables. This is the wrong dire...

Hi Adele, If you open the query is the date column still set to Date type: Date? What is the data type in Power Pivot? Are you able to share ...

Hi Sreedevi, Have you completed the Power Pivot course? I ask because your scenario sounds like you either don't have a dimension (dim) table for t...

Hi Chad, Microsoft say: "Power Pivot uses ACE for reading both types of files and provide an abstraction. It might have to do with that provider...

Hi Chad, No official word from Microsoft yet, but a fellow MVP offered this explanation: "If I were to take a wild guess, I would say that 32-bi...

Hi Michael, I'm not aware of a custom visual like this so your options are to: 1. Use the column and line combo chart and switch the inventory s...

Thanks, Chad. I'll ask Microsoft for an explanation. Mynda