Last seen: May 2, 2025
Hi Dieneba, If you click on the cog icon in the Final Data Query Source step, you'll see I did this using the Append Queries tool (Home tab of the ...
Hi Mardi, It's difficult to help with a screenshot. Please copy an extract of the data to a sample Excel file that you can share with us. Also incl...
Hi Dwight, Welcome to our forum! You can and should use Power Query for this. See this tutorial: consolidate Excel sheets with Power Query. Mynd...
Hi Leela, Welcome to our forum. Your question is difficult to answer because the image you have shared is too small and those helping would have to...
Hi Em, Your question isn't clear, which is probably why it's been unanswered for a few days now. Please upload a sample Excel file that illustrates...
Hi Dieneba, Thanks for the file. You can do this with Power Query. First, use a merge to lookup the BU in the original document and bring it into t...
Hi Andrea, Unfortunately, you can't change the space between slicer buttons. All you can do is change the button size. Mynda
Hi Dieneba, It's not clear what you're referring to as there is nothing in your file called Data 1 and Data 1b that I could see. However, you can u...
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...