Forum

Is it possible you loaded Current_data1 to the Power Pivot Data Model?

Please try uploading the file again. Be sure to click the 'start upload' button and wait until there is a check mark beside the file before submitting...

Hi Tim, Try choosing 'Custom' in the Allow drop down and then enter your formula as you had it in the 'Formula' field. Mynda

Hi Simon, Great to hear you're enjoying my course! Your objective should be done in Power Pivot using the time intelligence functions. I'm not s...

The Close & Load dialog is applied on a query by query basis on the assumption that you create a query, then close & load, then create the nex...

Hi John, What you want is a distinct or unique count of the customers. You can either do a distinct count with Power Pivot PivotTables, or with a r...

Hi Tom, Category names are text and therefore cannot have a custom number format applied to them that is dependent on a number value. You need to s...

Hi Annalisa, I think your source data (Course Requirements) table is in the wrong layout. You have a separate column for each course when you shoul...

Not that I'm aware of Alan. Even if you were to use a PC that has the correct license and connector, I think the query would fail to refresh on your P...

Hi Vicky, There aren't any other ways to merge that I know of. This post offers some suggestions on improving Power Query refresh times. Myn...

Hi Stine, Welcome to the forum! It sounds like you're trying to build your model before you've completed the courses 😉 In session 5 of the Po...

Hi Simon, I'm not sure I follow. Are you wanting to filter the data in Power Query to only return the data for the last 12 months? If so, I'm not s...

Hi Barbara, Excel doesn't have a Venn Diagram chart type, but maybe if you set the series overlap to 100% you'll get a column that shows the propor...

Glad I could help, Ernst. I'd say the blank cells will be a result of the exchange not providing the data. When they eventually provide the data t...

Hi Dave, There are not automatic settings in PivotTables that allow you to specify your financial year. Instead, you need to add a column to your s...