Forum

Hi Sheela, Websites like this are difficult to scrape data from because they use JavaScript to serve up the data. You can tell this is the case bec...

Hi Mac, I don't see how this will work when you sell some of the stocks and have those sale entries in your ledger. I thought you'd want to reduce ...

Hi Lili, If you clear the slicer selections, then apply your formatting, they should stick. No need to create a duplicate of your PivotTable etc. a...

Ah, in that case, you can use your new table to lookup the missing names and bring them into your query with the other staff data.

Hi Mac, If you want to track separate purchases and sales of the same stock, you'd need to add a column to your ledger that tags the stock purchase...

If you mean the button says '(blank)' or it's literally a button with nothing on it, then this means you have blank cells in the column your Slicer is...

Hi Nate, The simplest way would be to have a table with the 100 names. You can generate this using Power Query that completes the names that do mat...

Hi Chaitra, You have named the wrong column 'Durcomp'. It should be column I, not G. Also, you are missing your holiday dates from your WORKDAY.INT...

Hi Chaitra, It seems this is a character limitation in Mac Excel, so all you can do is try to shorten the formula. You could do this by moving parts ...

Wow, this is a new issue to me. Let me reach out to Microsoft to understand if there's a workaround.

Hi JHZ, Power Pivot can't do this. However, have you tried using fuzzy matching for this? See lesson 3.05 from the Power Query course on Merging Qu...

Hi Nate, I'm not following what you want to achieve. Please upload a mock up in Excel of your scenario that illustrates the issue and desired resul...

Well done! I wasn't sure if your dataset could contain future dates, or if it only contained dates up to the current period. If your dataset conta...

Hi Bax, Yes, and I've already used that technique to calculate the Date6WeeksAgo, so I'm going to let you figure out how to do it as practice. If y...

Hi Bax, You can create variables in your query that you can reference. See file attached. Mynda