Andy Sibbald
Active Member
Joined: May 6, 2021
Last seen: Apr 25, 2025
Last seen: Apr 25, 2025
Follow
RE: PQ - Combine Multiple Sheets _ Merge rather than append
Got it! For anyone else - this selects only the top (latest) file in the list. I have it based on the filename being in descending order (Just numbe...
6 days ago
Forum
RE: PQ - Combine Multiple Sheets _ Merge rather than append
Thanks Riny, thought that would be the case. With regard to just showing the latest, is there a way of ignoring the older files using the date c...
6 days ago
Forum
Forum
Replies: 3
Views: 99
RE: Reducing a Baselined Amount from two tables
Nice one Jessica. Many thanks for your help. Andy
3 years ago
Forum
RE: Reducing a Baselined Amount from two tables
Works a treat Jessica/Riny, thank you. Was this created in 365? Tried to step it through in edit and got errors. We are currently still using 20...
3 years ago
Forum
RE: Power Query Calculated Column referencing field from another table
Hi Phil, I though I had attached the file - obviously not. Profit calculated on the sum of Subtotal inc of Overhead Cost. I see what you mean. I me...
4 years ago
Forum
Forum
Replies: 3
Views: 222