Forum

Hi Jay, Becoming an expert in Excel is a long process. I recommend you focus on one area at a time. A good place to start is with an Excel course tha...

Hi Alison, I presume you've looked at the workbooks included for this section of the course? Can you please be specific as to which section of p...

Just a thought...I presume you've tried adding the status field to the PivotTable and filtering on 'Active' contracts only?

Hi Troy, This will return the 1st Jan of the current year: =DATE(YEAR(TODAY()),1,1) I don't recommend nesting this in lots of formulas becaus...

Probably better to ask Matt Alington this question:

With another && criteria.

No, there is now an additional table for the Customers to support the measure Matt wrote.

Hi Marcel, The INDEX formulas in the name manager, Chart_Dates and Chart_NAV, have the MATCH function in the column_num argument, it should be in t...

Hi Alison, I spoke to Matt Allington about the issue with the Lost Customers calculation and he came up with this formula: = SUMX ( FILTER (...

Hi Yan, You've got the right idea to aggregate your data to make your Power Pivot model more compact, but again, this is a job for Power Query to g...

Hi Yan, You should use Power Query to get and shape/filter your data before loading it to Power Pivot. I recommend you complete the Power Query cou...

Hi Lam, In that case you might be better off with separate charts for Local and Offshore. Mynda

😀 glad I could help. Hopefully you subconsciously absorbed some of the information while sleeping!

Hi Mardi, Correct. HASONEFILTER checks to see if there is a single filter applied to a row, Total rows are unfiltered, so it allows us to provide a...

Hi Alison, Please see attached. There are separate measures for the 'Grand Totals' (measures ending in 'Total'), which will support your waterfall ...