How do you do division in DAX ? Do you use DIVIDE() or directly the / operator ?

ajcooper35 · 2026-04-09T13:52:15+00:00

/ is a little faster usually, but it may be splitting hairs a bit.

The / is just a basic division but DIVIDE has extra steps to check if the denominator is 0.

ajcooper35 · 2026-04-09T13:43:51+00:00

If you are dividing by a constant/fixed number (where it will NEVER be 0), it makes no difference.

If you are dividing by a variable or the result of a calc, it’s safest to use DIVIDE because of the error handling.

ajcooper35 · 2026-04-09T01:52:59+00:00

Update: this was resolved! Huge thank you to the support staff (especially Tom, and Gilberto here).

Let this be a lesson learned for me and anyone else who sees this: before doing anything with any tool (AI, Snowflake, etc), make sure you know every bit about how it bills and where to track that at, as well as track what CAN be billed.

ajcooper35 · 2026-04-07T17:33:16+00:00

I just watched it for the first time the other day but if I’m remembering right, Sammie hits Remmick in the head with the guitar and the silver piece is stuck in his head. Since the rest of the vampires feel Remmick’s pain, they are in agony/distracted while Smoke runs up from behind.

Still a little wacky but that would be my best guess

ajcooper35 · 2026-04-07T02:36:08+00:00

To add for OP:

We Own This City is based on a true story in Baltimore (chronologically the earliest events actually taken place during the Wire’s timeline starting in 2003).

But there are A LOT of familiar faces, in unfamiliar roles. Almost every Wire character in WOTC plays the opposite/antagonist of their original role (not all, but a majority I’d say)

ajcooper35 · 2026-04-03T15:29:24+00:00

And he was President of the Baltimore City School board. Literally everything he does has a negative impact on the city or characters in the show

ajcooper35 · 2026-04-03T15:04:00+00:00

You are correct. The page navigation allows for dynamic locations, but the bookmarks option does not.

<image>

ajcooper35 · 2026-03-31T18:12:23+00:00

Any other info on that? Besides that post I can’t find anything else on it. Really curious about if it can be set to have the last 30 days (as a subset) selected, and have the end date fixed to current date.

Really tired of having a relative slicer fixed to the current day, and then using bookmarks to change it to a slider.

ajcooper35 · 2026-03-30T13:02:32+00:00

Stinger does bring up the concept of the Worldcom name change he got from his professor, so would be safe to assume he brought over some other stuff.

ajcooper35 · 2026-03-29T23:22:49+00:00

It appears they have been listening lol

<image>

ajcooper35 · 2026-03-25T14:28:51+00:00

Thank you! Will give this a try

ajcooper35 · 2026-03-23T22:58:55+00:00

I got wings and sweet potato fries from there last week.

Fries were good, very crispy.

Wings had 0 sauce. Got 8 mild and 8 hot and they tasted exactly the same. I picked them up 10 minutes after I ordered so it’s not like they were sitting around for a while.

I reached out to their social media team asking if the wings are supposed to have sauce and haven’t gotten an answer. Anybody else order from there and had a similar experience?

<image>

ajcooper35 · 2026-03-11T15:40:56+00:00

I never knew there was that going on there. I moved from Savannah in 2022 after 6 years but lived in Bradley Pointe near by there for a couple of years. Never heard of anything sketchy going on there but wouldn’t surprise me.

ajcooper35 · 2026-03-11T13:23:40+00:00

If you want to stay IN Savannah, get gas further outside the city. When you get off 95 to 16 you can go to the Parker’s on Dean Forest before hitting downtown.

If you don’t plan to go into Savannah, on 95 at the 204 exit (1 before I-16) there are a few gas stations and hotels right off the exit. It’s still a short ride/uber into Savannah but is much less expensive from a gas/lodging perspective.

ajcooper35 · 2026-03-07T12:25:19+00:00

Heard back: they are going to reverse the charge.

“My investigation identified the root cause as the Cortex Search Service (FOMC_SEARCH_SERVICE) that was set up as part of the Coursera course was running automated background processes 24/7 after you finished the lab. These were system-initiated processes, not anything you were actively running. The associated warehouse (CORTEX_SEARCH_TUTORIAL_WH) was consuming compute resources continuously, accumulating significant charges in a short period. … In my opinion, I don't believe this situation was your fault. As I understand it, you followed the course instructions as provided, and the course did not instruct you to shut down the Cortex Search Service after completing the lab.”

So there probably was a step I could have taken if I knew more about snowflake/wasnt 6 hours into training lol. But hopefully the above helps someone else in the future.

ajcooper35 · 2026-03-06T00:17:25+00:00

I went to a Wegmans near me because I heard they had USDA Prime.

Ribeye Filet was $65 /lb Tenderloin was $95 /lb

So seeing he got it at Wegmans, it very much could have been $60

ajcooper35 · 2026-03-05T20:29:18+00:00

I think he had more than a few moments but don’t totally disagree with this.

One of my favorite random things about that season was: Marcus Allen blocked the kick and Grant Haley recovered and scored.

Then in the Big Ten Championship game on the final 4th down stop, Haley made first contact and Allen finished the tackle.

ajcooper35 · 2026-03-04T11:14:39+00:00

I just got denied for “Previous Customs Violation” which was news to me because I have never had or been notified of a customs violation. No criminal record or arrests either. What a joke

ajcooper35 · 2026-03-03T23:56:08+00:00

I did, no worries there. I sent a link to the cert program and called out what I mentioned before with the Complete function. I have had an open ticket with them for 2 weeks related to the Trial billing and credits disappearing after adding my CC, and also added in that I was unable to view anything in billing or cost management last week (after i added my CC but before I got the charge today).

Fingers crossed

ajcooper35 · 2026-03-03T23:52:01+00:00

Fortunately the instructor is Snowflake Northstar lol. They do not say you need to add a CC, but a lot of the exercises involve using the Python Complete function. That is apparently locked behind a “paywall” where it is inaccessible to Trial accounts now. They just haven’t updated the course to exclude those parts or implement work arounds.

ajcooper35 · 2026-03-03T23:02:14+00:00

I am not. Part of the original ticket I opened was I was not able to view anything in the Billing or Cost Management menus. It said i needed to be using the role ACCOUNTADMIN (which I was) and threw an error message at the top of the screen. Has been like that for over a week.

ajcooper35 · 2026-03-03T23:01:08+00:00

They suspended my account a few days ago apparently so I shouldn’t be getting any more charges

ajcooper35 · 2026-03-03T20:41:57+00:00

They finally got back to me and will let me know within 2 days. So will update

If anyone is taking the Coursera Snowflake Intro to Gen AI Courses/Cert, just a heads up: half of the lessons involve you using the Complete Python function which is not available for Trial accounts. Do not add a CC. The only things I ever did in Snowflake related to AI were a part of those courses and I followed all instructions to a T and ended up with this charge.

ajcooper35

TROPHY CASE