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’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.

Also pandas and matplotlib but maybe that’s just me.

-Data Nerd

Yeah but fuck all that python is good enough for most beginners. Variables, scope, loops, functions, operators… Once you get some of the principles down switching to C++ or similar isn’t nearly as bad.

Being a person that tried to learn C/C# from scratch in my early days python was a good gateway language.

My elderly dad fell for something similar trying to call HP support, he googled the number and the top result was some bullshit. They had him set up remote access and compromised all his data. Old man had to reset everything.

He called me saying what happened, I had him shut down and unplug. I recovered what I could but he lost a lot of data.

This shit should be illegal. Like, I’m sure it is technically but there shouldnt be unofficial sponsored results above legitimate sources.

Fr my dog loses her shit over pumpkin and greenies she will love these.

Yeah I get this too if my beard grows for more than a couple days. Also the back of my scalp if my hair gets really long.

I love that realization when I throw some hacky shit together and it somehow works first try.

When I try to be organized and meticulous nothing works and I eventually give up.

First

I love scrolling through the nuthouse that is YouTube comments, it’s always so unhinged.

Forkyz ❤️

You guys are only using 8 joins?

Unrelated but alt+e+s+v is so ingrained into my muscle memory. I should really get a macro pad

Very cool post, thanks for sharing

Yeah unprofessional/bad practice, I would flip off the notifs and just decline behind the scenes.