Forum

Andy Sibbald
@andysibbs
Active Member
Joined: May 6, 2021
Last seen: Apr 25, 2025
Topics: 3 / Replies: 5
Reply
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
Reply
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
Reply
RE: Reducing a Baselined Amount from two tables

Nice one Jessica. Many thanks for your help. Andy

3 years ago
Forum
Reply
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
Topic
Forum
Replies: 5
Views: 70
Reply
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