Forum

Hi Charmaine, Select each series one at a time and change the fill colour. Excel will then remember the colour for that series. Note: this doesn't ...

Hi Tyler, I just used the filter buttons. You'll see there is a filter on the Last Invoice query Invoice Date column. Mynda

Hi Anthony, Welcome to our forum. It's great to see you're trying some different approaches. The formula in my example is designed to work with ...

Hi Tshepo, Welcome to our forum! Unfortunately, Excel isn't designed to work the way you describe. I recommend you use another cell to allow the...

🙂 glad I could help!

Hi Karen, There are no tables Power Query can identify on that page. If I browse to the 'Trends' data it displays some charts, but these are in an ...

Yes, DAX measures can be written for one table.

Hi Tykru, There's no built in way to calculate it but this post offers a solution. However, it is simpler to do this calculation in Power Pivot usi...

Hi Mike, Thanks for sharing your file. If you look at my file you'll see the PivotTable on the Actives sheet uses the Date field, which is the snap...

Hi Sue, Great to see you're making progress. The 'Month' button isn't designed to show the selected month. It's simply a drop down button that allo...

Hi Mike, It's great to hear you've been able to use the techniques in your own work. I'm confused about your question because the top formulas a...

Hi Luna, You can transform the text on the Transform tab > under the Format drop down you'll find Trim and Clean. Then you can set all text to '...

Hi Bob, This will be because in Excel 2010 Power Query couldn't load the data directly to the data model/Power Pivot, whereas in Excel 2013 the pat...

Hi Angela, When you place a zero in the row or column number arguments for INDEX it will return the whole row/column. Tip, wrap your formual in SUM...

Hi Karen, Thanks for clarifying. Sometimes when I download Excel files the queries are being removed. I downloaded it again and I can see it now. T...