Forum

Tom Turner
@ttsurv
Eminent Member
Joined: Mar 9, 2022
Last seen: Jan 24, 2025
Topics: 6 / Replies: 14
Reply
RE: Separating one table into two and then appending

Hi Riny, thank you for this. It looks good. It's making me think I need to simplify things a bit on my side.

5 months ago
Forum
Topic
Forum
Replies: 2
Views: 207
Reply
RE: Running total in PowerQuery for selected items

Hi Mynda Thank you for looking at this. I did a typo when I said suspect, it should have been suspend to read "For planned changes, I want the...

2 years ago
Forum
Topic
Forum
Replies: 3
Views: 67
Reply
RE: Having a differences column as opposed to a grand total column

Hi Riny, Could you please let me know if your technique of showing differences between group totals could work in the advanced set-up I have t...

2 years ago
Forum
Reply
RE: Having a differences column as opposed to a grand total column

Hi Riny This is great thank you. I can't think of any more tweaks. The other issues doesn't seem to make much sense. Is this really goin ...

3 years ago
Forum
Reply
RE: Having a differences column as opposed to a grand total column

Hi Riny, Thank you for this. This works very well, however, sum of the Pivoting functionality is lost when duplicates are removed. I'd like to...

3 years ago
Forum
Reply
RE: Having a differences column as opposed to a grand total column

Hi Riny, This won't work per the screen shot. This makes sense because the item Contingency for rotting rafters does not appear in Revised_cos...

3 years ago
Forum
Reply
RE: Having a differences column as opposed to a grand total column

Thank you for this Riny. This works very well when Original_cost_estimate and Revised_cost_estimate are the same, but not if there is a unique item in...

3 years ago
Forum
Reply
RE: Having a differences column as opposed to a grand total column

Thank you Riny and Jessica for looking into this and apologies for the delay - I have been travelling to see my family overseas. I also had a bit of a...

3 years ago
Forum
Reply
RE: Having a differences column as opposed to a grand total column

Hi Jessica, thank you for this. I believe this is also using Power Pivot like Riny's solution. Your solution works great albeit the AA29 doesn't equal...

3 years ago
Forum
Reply
RE: Having a differences column as opposed to a grand total column

Hi Riny, Thank you for this. This definitely works and answers my question. I am interested to carry out some other transformations inside Pow...

3 years ago
Forum
Page 1 / 2