• 0 Posts
  • 33 Comments
Joined 2 years ago
cake
Cake day: July 2nd, 2023

help-circle



  • 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 :)












  • Yeah if you’re out of shape just go for some walks. I have a dog so I have to take 3 walks a day. I could just take her to a patch of grass but she needs exercise too so I at least take her around the neighborhood.

    All that to say, those little walks are sometimes the only part of the day where I can think and process my thoughts. I highly recommend going without headphones for that reason.







OSZAR »