Forum

Hi Luciana, If you add a column containing a formula, then this will work because the formula is the same all the way down the column, however you'...

Hi Jan, What you have is two fact tables; one for revenue and one for costs. Please watch sessions 6.07 and 6.08 of the Power Pivot course for how ...

@SunnyKow, interestingly, CHAR(160) didn't work consistently in my testing, hence my reply. Not sure why. @Saliha, did you try the formula approach...

You're welcome, Cheryl. Glad you're enjoying the courses 🙂

Hi Jan, It's difficult to visualise completely, but I'd say if you can aggregate your data to yearly totals in Power Query at the level of detail y...

Pivot Charts are designed to adapt to the amount of data in a PivotTable while maintaining the overall size of the chart area. If you want to lock dow...

Thanks for the sample file. Click the filter drop down in column A > Value filters > Greater than > 10. Mynda

Hmm, there's no such version as Office 2017. Can you check again? A formulaic approach is to use SUBSTITUTE to remove the $ sign and the characters...

Hi Mohamed, Welcome to our forum! I suggest you use a scroll and sort table for your 100 employees scorecard. I hope that points you in the right d...

Hi Cheryl, The DISTINCTCOUNT function doesn't return a column, it returns a scalar (single value). I'm not sure how you'd want to use a distinct co...

Hi Howard, Looks like a good overall course. I think it's more focused on the accounting fundamentals of budgeting as opposed to teaching Excel, bu...

Yes, you should be able to get those new sheets and then append them to the original query.

Hi Saliha, Thanks for sharing the file. As expected, the numbers are formatted as text, which is caused by the $ sign with several spaces after it....

Hi Chris, I'm not sure why you'd want to separate the data, but I'd be inclined to use PivotTables to extract the data (first add back the column t...

Hi Saliha, I can't tell from the data pasted into the forum thread, I'd need to see your Excel file, but I suspect the data has come into Excel as ...