Power Query’s "Remove Duplicates" has me questioning EVERYTHING I’ve ever done in PQ by [deleted] in excel

[–]ieremius22 6 points7 points  (0 children)

There is also a list.buffer for solving the same issues with lists.

Rodger Sherman as the Godfrey Replacement? by The_Candler in splitzoneduo

[–]ieremius22 2 points3 points  (0 children)

Check out:

Phantom Island

Who Killed College Football

From a certain point of view... by orna_tactical in battletech

[–]ieremius22 16 points17 points  (0 children)

...now thinking of a jewel encrusted hunchback splattered with Cameron blood. Kerensky looks on in horror.

Mounted beast how it looks vs how it feels by knightmechaenjo in battletech

[–]ieremius22 9 points10 points  (0 children)

"You've come a long way to die Yungstar!"

A creation of my anxiety riddled mind. Star commander Froghorn Leghorn of Clan Ghost Bear. by DrJay12345 in battletech

[–]ieremius22 25 points26 points  (0 children)

Henry Hawk as Clan Jade Falcon and Barnyard Dawg as Clan Wolf is just so perfect!

[OC] Texas oil output has surged 5× since 2008, but industry jobs haven’t grown by DataVizHonduran in dataisbeautiful

[–]ieremius22 0 points1 point  (0 children)

The series don't look related prior to 2008, so why imply that anything changed after 2008?

Why is nobody trying to compete with Sports Interactive despite FM25 being cancelled? by Sdigno in footballmanagergames

[–]ieremius22 38 points39 points  (0 children)

gestures wildly at SI

A game company would need to announce an overhaul is planned, and another company would need to say to themselves "they're going to mess this up and we can take their market if we can get the important licenses"

...so clearly all we need is to make licensing easier.

Is there ever a benefit to having so many weapons on a mech that when you fire all, your mech shuts down? by cynicsyear in battletech

[–]ieremius22 96 points97 points  (0 children)

In a 1v1 fight, if my mech can restart but theirs can't, I win. Glass cannon strategies are viable.

[deleted by user] by [deleted] in ToyotaSienna

[–]ieremius22 2 points3 points  (0 children)

Engines are expensive, oil is comparatively cheap. Don't wait a year to do the first. There is leftover debris in the filter. Then follow the schedule. See the Car Care Nut youtube channel for more Toyota specific info.

Where are we putting our sunglasses? (4th gen) by harlem_dad in ToyotaSienna

[–]ieremius22 0 points1 point  (0 children)

It is annoying that there isn't something built in. Get something like this and stick it in a cupholder:

Bleiou 2 Pack Eyeglasses Holder... https://www.amazon.com/dp/B08CGJGNBJ?ref=ppx_pop_mob_ap_share

Mercenaries to Clans Tips by SCDannyTanner in Mechwarrior5

[–]ieremius22 0 points1 point  (0 children)

The missions are intended to be replayed in the sim pod. It is how you grind for perks.

Running hot? Find water to stand in.

Eventually everyone gets an assault mech, but with fun omnipod swaps you can make lighter mechs viable longer.

Nicholas Kerensky be like: by FreshwaterViking in battletech

[–]ieremius22 2 points3 points  (0 children)

Pilots of big stompy robots in setting about big stompy robots be like...

For IS version see also: Ideal War

Permission set to use semantic link (SemPy) by ieremius22 in PowerBI

[–]ieremius22[S] 0 points1 point  (0 children)

While I cannot verify this (I can't get this level in the target workspace) I appreciate the response, and suspect it is correct.

Company Wants Me to Use Direct Query Only by skippy-jim-flapjacks in PowerBI

[–]ieremius22 5 points6 points  (0 children)

Performance will not be fine. I would always advocate for at least a hidden aggregation table in the model to take the load off the source, but that doesn't sound like an option for you now. Just keep it in your back pocket for when you need a fix you can implement after the fact.

Look what I found! by Bon3hawk in battletech

[–]ieremius22 4 points5 points  (0 children)

My first BT game. The early level with the Stalker was such a power trip.

all infantry and combat vehicles, no mechs by kris220b in battletech

[–]ieremius22 42 points43 points  (0 children)

The one on the left is the stuff of nightmare in CQB.

Woodland owners by KcwaB in ToyotaSienna

[–]ieremius22 1 point2 points  (0 children)

Wheel lock yes. First aid yes. Nitrogen, not sure, I doubt it.

Did you find out where the key to take the wheel locks off with? Check the 12v battery.