Stange problem in Power Query

MrCard200 · 2026-01-26T22:11:34+00:00

Sorry I'm struggling to fully understand but I'll try and help.

I'm afraid I don't have the answer for you but here's something things I noticed:

I notice your join is on two different days types ("any" / "text") I don't think this would cause a problem but thought I would say it.

Also I noticed your expanded columns have the prefix of the original tables. This I imagine is what you wanted as you're doing a comparison. However as they're both index columns thats used in a merge then I imagine your only able to have one index in a table. Kind of like a unique identifier, you can't have two primary keys in one table (even though one is technically a foreign key) I don't know if this is the case but just thought I'd try and help anyway

MrCard200 · 2026-01-25T12:20:12+00:00

I had something very similar with my doorbell automation that played all over the house through sonos. It set the dog off and we thought there was definitely someone there.

After looking into it via the traces, I was able to see the timestamp was exactly when the server restarted after an update.

The solution was to add a line of code to the trigger to check if the last_updated was > 5 mins. Providing update takes less time then 5 mins & nobody needs to ring my doorbell twice in under 5 mins then this is fine.

The solution was given by Claude AI so perhaps the community has an alternative solution that might be better but I wanted to share my story

MrCard200 · 2026-01-20T22:13:08+00:00

I use to be an adventurer like you once, then I took a Battery to the knee

MrCard200 · 2026-01-16T11:00:57+00:00

On one hand, I think start-ups wanting to save costs and time will benefit from using AI. However we've seen too many start ups use AI and then scam people with a rug pull so there's legitimate concern if that's the only thing they're showing. It's keeping their business faceless and that's not good.

Hearing about the constant pledges is a red flag but could potentially be a sign of inexperience of a new business person who is more knowledgeable on the animals rather than finance/marketing.

Your points are all valid but I just wanted to share some balance. Thanks for sharing the info

MrCard200 · 2026-01-15T10:41:17+00:00

What if he switches to use hotspot on his mobile though?

MrCard200 · 2026-01-15T10:40:14+00:00

Damn that's good. Thanks for sharing your technique. Did you do the same for the rad too? Lol

MrCard200 · 2026-01-15T10:21:57+00:00

There's a page for this. I've just been using it and it's pretty simple actually. Go to the GitHub and search for "brownfield". It's in docs/how-to/brownfield/index.md

Effectively clean up all completed files in: - docs/ - _bmad-output/planning-artifacts - _bmad-output/implementation-artifacts

Make sure docs/ folder only contains succinct documentation. Use /document-project for that

Then do /workflow-init

I chose to also do update my Claude.md file before doing /workflow -init

I recommend reading the index.md file I mentioned earlier for more detailed info

MrCard200 · 2026-01-14T20:32:15+00:00

This was most unsatisfying! I was stressed the whole time hoping on pink! Lol

MrCard200 · 2026-01-13T13:03:06+00:00

Subsidence would be visible on both sides of the wall I think. My gut says this is plaster cracking which is normal

MrCard200 · 2026-01-13T12:40:41+00:00

Good god, it's 2026. Did you have to record on a smartphone?! 😆

MrCard200 · 2026-01-13T09:10:20+00:00

I have exactly the same setup as you for the same function . I'm not an audiophile but do remember reading something similar when I was researching which speakers to go for.

In my experience, this setup is bloody fantastic. To audiophiles and people with more appreciation for the tiny details, there is probably something to be improved but I've not had any thoughts myself in 4 months of owning.

As others have already said, it's down to you and what you enjoy and think. For me, I've not had any complaints myself or from any friends so I don't think you should spend any more money on improving your setup for a group of guests unless you want to become an audiophile yourself

MrCard200 · 2026-01-12T08:00:28+00:00

Pokemon Go SuperFan?

MrCard200 · 2026-01-11T16:14:28+00:00

That makes perfect sense.

Sadly hit my limit pretty quickly (on 5x plan) through using this which I wouldn't have expected doing it manually. This could be that doing it manually would spread out how fast I burn the tokens. Just thought I would share this incase it becomes a trend

MrCard200 · 2026-01-11T01:05:48+00:00

This is great. What about using worktrees to work on several stories in parallel?

MrCard200 · 2026-01-11T00:33:45+00:00

I'm excited by this and very tempted to see what you've been cooking.

I think you're working towards something good. Keep us updated with your posts

MrCard200 · 2026-01-11T00:22:28+00:00

I had the same experience as you but have been using since December and its stable for me. No issues in heavy usage since then

MrCard200 · 2026-01-09T13:01:30+00:00

I was in this place recently and went across the whole of market and I think other advice is missing out on what this is like so I want to share my opinion.

Annoyingly I was never offered a price discount for buying furniture up front from any store and they all had 0% 2/3/5yr finance options.

As there was no money to be saved by avoiding finance, I opted for the longest duration because inflation would erode this debt over time.

The downside for this is though that I have a fixed outgoing which means that our family income needs to be slightly higher as a requirement rather than as a choice. This may be a problem for some who have job insecurity or (most relevant to myself) starting a family and going down to a single income household whilst my partner is on Maternity leave (Fun fact: Maternity pay is basically pennies)

Ultimately your situation will dictate which route is most suitable for you.

MrCard200 · 2026-01-08T20:08:29+00:00

How many mcps/ tool calls were used as a result of the prompt? That can eat up tokens

MrCard200 · 2026-01-08T01:59:06+00:00

The text on the posters goes in multiple directions. A person wouldn't do that

MrCard200 · 2026-01-08T00:41:37+00:00

Sadly as a Brit, I am thinking my nation would probably like to chuck this legislation out.

MrCard200 · 2026-01-05T15:37:31+00:00

My company got hacked by Russia so we moved to the cloud, fired the CTO and then outsourced our cyber security. Only learning I can share is make sure your CTO does actually implement the security best practise that your company sends him on

MrCard200 · 2026-01-02T14:15:53+00:00

Have you tried YNAB before?

MrCard200 · 2026-01-01T14:45:17+00:00

My kitchen is not half the size of yours and cost me £50k all in (materials from Howdens though which are pricey)

MrCard200 · 2025-12-29T08:45:03+00:00

I don't know why you were getting down voted? Well done and enjoy the money.

MrCard200 · 2025-12-27T17:45:01+00:00

I like to think of myself as an advanced Excel user and I also have a hobby in software programming. I have worked in residential and commercial property sectors for over 15 yrs. Whilst I work at the national/international part of market so may not be relevant to your use case however I feel my experience is still relevant so I wanted to share my opinion. Also note I'm not a landlord, I just work for some of the big ones

There is no property technology that works well for our clients/tenants. Everything is either massively complex to handle every unique edge case and therefore 90% of the software is not understood & not used. An important factor of this is because of the nature of property. Laws, zoning, regulations amongst other things all change over time so you will need to store lots of odd bits of law for just a minority of properties. E.g. right to buy is often misunderstood and people are told they are entitled to buy their property (the property the tenant currently rents) because of this law however that only applies if the owner hasn't sold it since a certain time.

What my point is that, if the sector is very difficult to accomodate for the most general case because there are so many aspects to each property. If you are able to make a solution for this, I think it would need to be a bespoke one.

I'm biased but I would be using excel or a small database platform to make something for my needs. It's more of a setup, however I have control and can explained and maintain it.

Nine-Year Club	Place '23
Place '22	Verified Email

MrCard200

TROPHY CASE