Last seen: Aug 5, 2025
Hi James, The screenshot and the error don't match. The error is referring to date time string 45118 which is the date 11 July 2023. This date is i...
Hard to say without seeing the file. Are you able to share it? If required, remove the sensitive information.
Hi Ayal, The dreaded apostrophe can be removed with Text to Columns on the data tab, or by loading the data into Power Query and setting the data t...
Hi Christopher, Welcome to our forum! You can use the SUMIFS function for this: Mynda
In that case I'd say it's a bug. You can try updating Excel to see if there's been a fix. If that doesn't work, you're welcome to share your file with...
Like Riny said, the functionality is almost the same on a Mac as it is on a PC, but there are still some differences. Unfortunately, there's no magic ...
Hi Aaron, I tested your measure in my file and it didn't return an error. I wonder if you're expecting to see values in the early years because the...
Hi Celeste, Are you loading your data from Power Query to Power Pivot or only from Power Query to an Excel Table? If the former, then it should go ...
I don't have Premium so I don't think it's that. I do have Pro, so maybe it's related to that, but I doubt it. It's more likely to be some regional se...
I'd have to see the PDFs and your query to troubleshoot as I can't reproduce that issue. If the data is sensitive, you can email it to me website at M...
Hi Dieneba, Ideally your data should be modelled in a star scehma design This means creating dimension tables for attributes that are not requi...
At the Navigator dialog box are you able to see the tables and select them by checking the box for 'select multiple items' and then checking the box f...
Hi Patrcia, It's difficult to troubleshoot without seeing the query and files. It's particularly odd that some data comes in but not all. I won...
Hi Charles, There are a few ways to tackle this and depending on which version of Excel you have, there are also some functions that you can use. ...
Hi Filipa, It's difficult to be specific without seeing your file, but have you watched lessons 9.06 - 9.08 on the ALL, ALLEXCEPT and ALLSELECTED f...