Last seen: Apr 22, 2025
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
Use Riny's solution if your data was loaded via Power Query. If not, in the Power Pivot window, you can click the top left corner of the table where t...
Hi Sirajus, That is a very small screen you're using! First, I would minimise the ribbon by double clicking on one of the ribbon tabs. You can s...
Interesting question, Danielle. This post answers it for you. Mynda
Hi Yen, It will depend on the structure of your model, but generally speaking, it would be like this: GrossMargin = Sales[SalesAmount] - Sales[T...
Hi Kevin, It looks like an update has added functionality that allows you to apply formats to all series in one go, or individual bars by selecting...
Hi Kevin, Can you please send me a screenshot of what you see under the Admin Portal (accessed via the cog icon) > Tenant Settings > Integrat...