Last seen: Jul 8, 2026
Hi Trond, Opened the pbix file but can't really use it as it links to sources on you local disk. But I did look at the M-code and notice that you f...
Your picture points to the Merge Columns button. As said, you need to select at least two columns for the button to become active. Adding a blank q...
I suspect that your system uses the semi.-colon as the list separator. Try =LEFT(A2;2)&","&RIGHT(A2;LEN(A2)-2) Of course, you are aware...
Well, if the dates are not the same, you'll end up with two "yes" rows. The first step in the Merge query is indeed matching up the Suppliers as yo...
The "No" doesn't just disappear randomly. Sorting by supplier (ascending) and Yes/No (descending) will put a "Yes" row above a "No" row for those tran...
Provided you are on Excel for MS365 or 2021, you can use TRANSPOSE and FILTER. Let's say the list of keywords in Sheet2 is in a named range called "my...
Change the named range "List" to be X2:X10. I.e. do NOT include empty cells and it shall work. Wrap the formula in IFERROR if want to avoid the #NUM! ...
Fair enough. Then perhaps another rather simplistic approach will work, as demonstrated in the attached file. No need for "earliest_date".
Can't really follow your intentions, based on text and a few screenshots. The xlsx you attached was the mock-up you provided earlier, but you changed ...
You didn't attach a file. Please try again and don't forget to press the Upload button once you added a file.
Hi Femco, I couldn't get Jessica's proposed solution it to work, but the attached workbook contains a small scale example on a table with just 5 co...
Hi Trond, The "earliest_transaction" serves as a variable used to filter out contracts from Table B (before merging) that have an expiry date befor...
Perhaps the attached (updated) file contains the solution you asked for.
Hi Robert, Glad I could help! And, by the way, DAX relates to Power Pivot / Data Model. You'll need to dive into M, the code language that drives P...
That may be the reason. Don't believe that the 2019 version has this feature. But I may be mistaken and have no way to check it.