Nah just stupid number formatting, my UPCs regularly turn into scientific notation or my UOM automatically convert to a string =“12” which ruins math operations so first I have to make a helper column =NUMBERVALUE([@UOM]).

Or being unable to convert datetime to a simple date for date calculations without loading the table into power query and transforming it there. You can change the format into short date but if the actual value is datetime it will still throw an error but now the type issue is hidden, so have fun reading docs and troubleshooting until you realize your mistake :)

Best I can do is 7.45678e17

Yeah if its something ad hoc I’ll paste values but for sheets meant to be maintained I’ll do it in PQ through merges or calculated columns. Lookups get the job done but they are expensive ;)

Damn you just described my role but everything happened within a span of 3 years

Xlookup works fine for like 90% of cases, I save index match mainly for when I need to return multiple lookup values. In which case I load into BI because I always forget how index match works 😫

I did this for a while but my boss said it looked bad that I leave before everyone else and wasn’t fair to customer-facing peers that had to be there certain hours…

I’m with that guy, I get out of work at a set time I like to have some daylight after work. Doesn’t matter what time I wake up, I don’t wanna do things before work I just like to see the sun after work it gives me something to look forward to.

Hah I’ve thought of this maybe I can look into it, I’m an amateur Arduino enthusiast but it might even be more simple than that.

The same crossed my mind but that would be hell for everyone around you on a sunny day. Sometimes even just a car with a lot of chrome is annoying 😔

I recently had a high beam tailgating me. I moved my side and rearview mirrors to reflect it back and he passed me on a double yellow line with him in front of me I just turned on my own high beams. He turned off soon after but I hope it made his day a little more frustrating ¯_(ツ)_/¯

Dude YES. 20 years ago driving in the country you see some high beams in the distance and people would go back to low beams as they get around a corner or crest a hill when they see other cars.

My commute is through a lot of schools and parks and pedestrian crossings and it’s somewhat poorly lit, so everyone has high beams on regardless of traffic but as a result I can’t see shit. If there’s oncoming cars stopped and a pedestrian tries to squeak through I literally wouldn’t be able to tell.

It’s gotten so bad, either people have their brights on all the time or they’re not adjusted properly. In either case headlights DONT HAVE TO BE SO BRIGHT.

I’ve noticed this a lot lately. Extremely long winded and well written emails that could just be a few bullet points.

Give me the human version please. If your email fills my entire screen it’s going through the GPT gauntlet and if your point is lost that’s kinda on you.

If you ever find a way around this let me know, it’s maddening. Especially overseas contacts where I have to wait a day in-between responses, sometimes it takes a week or more to get what I need.

Thanks for the update I was still thinking about this 😂😭

The different pupil sizes is usually indicative of brain injury, if you haven’t already maybe get that checked out. It can be just an eye abnormality (rare) but it’s usually not a great sign…

Did you fry the bread? It looks so good… Except the ketchup give me ranch

One of my all time favorites. There’s something special about the N64, these games were magical as a kid and a lot of them still hold up today.

I used to play through Ocarina almost every year but it’s been about a decade and I started a playthrough last week. People have made some incredible progress on updating textures and such to make the game look more modern 👌

I used to work next to a huge arena. Every time there was a sold-out show, the cell service would be rough the whole time from people sending videos and such. When the shows let out it would be a complete meltdown while people tried to get Ubers.

Such a concise and clear explanation 👌

Right at eye level to blast everyone in a sedan 👌