Last seen: Jul 7, 2026
Let's say you have table "Table1". Its first column is called "Ref" followed by a number of other columns. Before grouping by "Ref", find the colum...
Same thing happened to me when I tried opening your xlsm file. But you can right-click on it, then 'Save link as'. If you can't get it to work that wa...
Not sure I understand what you mean by: "I managed with power query to link the data in the destination file so when I add a new project in the sou...
Please have a look at the attached file, being yours with a spreadsheet formula added that does what you asked for. Thus, it's not done in Power Query...
Changed your calculation for the 'Aktuel' part in R44 of the needle chart. I also set the pie to start at 270 degrees. See if this resolves your probl...
The data is quite 'dirty'. Easiest to clean it up with Power Query. The attached file does just that. I've created some basic queries to give you an i...
Allthough you crossposted (without mentioning it) as indicated by Alan, and received quite a few answers, I take it that you were not satisfied as the...
@Velouria Oh my, forgot about that option to start looking from the End. 🙂 By the way, set the delimiter to " (" and that we don't need the Tri...
Let me summarize a bit. You have data that could be: Fund A - Class A - Income (USD) 17.928 @ 5577.867000 Fund B - Accumulation (GBP) 294.899 @ 339...
On the Transform tab, Extract, Text before delimiter. Enter " (" i.e. space and left parenthesis without the quotation marks as the delimiter. This...
Fairly straight-forward. See if you can follow the steps in the attached file. Come back here if you get stuck.
That will be a challenge. You could start with listing out all possible honorifics. Then you can at least identify the rows that have one and extract ...
It took a while, but glad we figured it out.
Yet again, I had another idea! Create a calculated column in dimServices, called Svc, for example: Svc = if( [Services FIltered]=1, dimService...
I ran out of ideas. Sorry.