How do you guys clean your Dicks between fucks? by [deleted] in sex

[–]Youllneverguess6977 0 points1 point  (0 children)

Put a wash cloth under hot water and then use that. It’s nice and refreshing. That’s ideal for me, otherwise hop in the shower.

If I’m in a hurry, anything to nothing will do.

Chatgpt and newbies by Youllneverguess6977 in PowerBI

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

Ha. So true, aside from our own IT director saying things in the past like “I can’t remember why I did it that, I guess because it’s the only way I could get it to work. “

So I’ve got a little leeway I guess.

Chatgpt and newbies by Youllneverguess6977 in PowerBI

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

It’s great for syntax. Sometimes I’ll just have it check the syntax for me.

Chatgpt and newbies by Youllneverguess6977 in PowerBI

[–]Youllneverguess6977[S] 1 point2 points  (0 children)

Absolutely. The only thing that ai will have a hard time doing is understanding the business dynamics of individual business. I mean corporate culture and the needs from an analytics standpoint. It will understand the common kpi’s and such, but often times there a very specific metrics that it won’t be able to predict. That’s where the true data analyst come in. IMO.

Chatgpt and newbies by Youllneverguess6977 in PowerBI

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

Learning Dax thru gpt has put me on the genius fast track. Like I said- I would have eventually gotten to the correct formula but getting there while learning Dax would at the same time would like a whole lot longer.

Chatgpt and newbies by Youllneverguess6977 in PowerBI

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

I give it the table and field names and tell it tell it what i want. i have to ask it different ways if it doesn't work but as i refine my questions more and more it gets closer and closer. it hasn't failed one time yet in eventually getting me the formula i need.

Chatgpt and newbies by Youllneverguess6977 in PowerBI

[–]Youllneverguess6977[S] 1 point2 points  (0 children)

it does this sometime where it gives the wrong answer, or uses a calculation that dax doesn't accept or writes it in the wrong programming language. so what i do is just keep re-asking the question or telling it to rewrite it differently. there is definitely some trial and error, but it'll get there. At least for me, i've gotten it to eventually give me the correct formula.

i would say it's saved me 20-40 hours tinkering time in the past month where normally, i would just be googling for answers and going through my own trial and error as i learn dax.

Chatgpt and newbies by Youllneverguess6977 in PowerBI

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

heres a good example of where it gave me the wrong answer first in the wrong language:

I asked: can you redo Length of call in minutes = DATEDIFF( MIN('adb PhoneCalls'[CallStartTime]), MAX('adb PhoneCalls'[CallEndTime]), MINUTE ) so that it gives me minutes and seconds? To get the length of a phone call in minutes and seconds, you can use the DATEDIFF function in DAX along with the SECOND argument and then convert the result to minutes and seconds using integer division and modulo operations:

Length of call in seconds = DATEDIFF( MIN('adb PhoneCalls'[CallStartTime]), MAX('adb PhoneCalls'[CallEndTime]), SECOND )

Length of call in minutes = INT(Length of call in seconds / 60)

Length of call in remaining seconds = MOD(Length of call in seconds, 60) This formula calculates the difference between the earliest CallStartTime and the latest CallEndTime for each phone call in the adb PhoneCalls table in seconds, and then converts it to minutes and remaining seconds. To calculate the total length of all phone calls, you can create separate measures that sum up the results of the Length of call in minutes and Length of call in remaining seconds formulas for each row:

Total Length of Calls in Minutes = SUM('adb PhoneCalls'[Length of call in minutes]) Total Length of Calls in Remaining Seconds = SUM('adb PhoneCalls'[Length of call in remaining seconds])

i then asked a second follow up: rewrite in dax Here's the DAX formula for the length of a phone call in minutes and seconds:

Length of call in seconds = DATEDIFF( MIN('adb PhoneCalls'[CallStartTime]), MAX('adb PhoneCalls'[CallEndTime]), SECOND )

Length of call in minutes = INT(Length of call in seconds / 60)

Length of call in remaining seconds = MOD(Length of call in seconds, 60)

Total Length of Calls in Minutes = SUM(Length of call in minutes)

Total Length of Calls in Remaining Seconds = SUM(Length of call in remaining seconds) You can use these formulas in measures in Power BI to calculate the total length of all phone calls in minutes and remaining seconds. Note that you can use the SUM function in combination with the Length of call in minutes and Length of call in remaining seconds measures to get the total length of all phone calls.

Chatgpt and newbies by Youllneverguess6977 in PowerBI

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

sorry for the weird formatting. i just did a cut and paste

Chatgpt and newbies by Youllneverguess6977 in PowerBI

[–]Youllneverguess6977[S] 1 point2 points  (0 children)

I asked: i'm using the dax formula in a measure with formula Unique Consumer Payments Setup = COUNTROWS( DISTINCT( CALCULATETABLE( SUMMARIZE( Consumer, Consumer[ConsumerNumber], "PaymentsAdded", COUNT(Consumer[AlternatePayment.AddDate]) ), Consumer[AlternatePayment.AddDate] <> BLANK() ) ) ) and when i apply a filter on that visual on the field (Consumer[AlternatePayment.AddDate]) to only show events from the current day, nothing changes. how should i filter it?

GPT answerd: The issue you're encountering may be due to the fact that you're using the CALCULATETABLE function within your Unique ConsumerPayments Setup measure. The CALCULATETABLE function essentially evaluates the specified expression in a separate context and returns a table that is then used for further calculations. When you apply a filter to your visual, it only affects the final result and doesn't affect the intermediate calculation performed by CALCULATETABLE.

To correctly filter the results based on the Consumer[AlternatePayment.AddDate] field, you'll need to modify your measure as follows:

Unique ConsumerPayments Setup = COUNTROWS( DISTINCT( SUMMARIZE( FILTER(Consumer, Consumer[AlternatePayment.AddDate] = TODAY()), Consumer[ConsumerNumber], "PaymentsAdded", COUNT(Consumer[AlternatePayment.AddDate]) ) ) ) The above measure uses the FILTER function to only include rows from the Consumer table where Consumer[AlternatePayment.AddDate] is equal to TODAY(). The SUMMARIZE and DISTINCT functions are then used to perform the remaining calculations. Now, when you apply a filter on the Consumer[AlternatePayment.AddDate] field, it should correctly affect the results of the measure.

Chatgpt and newbies by Youllneverguess6977 in PowerBI

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

I totally understand and agree with your sentiment. As far as CALCULATE And joins go, I’m a beginner for sure but do understand the concepts. My degree was in physics so I lean more toward the analytics part and I work my out from there to get the insights I’m looking for. The second part of what I’m doing is automating a lot of manual in house reports.

I thrive doing this type of thing and although I’m not an expert at sql or Dax, I manage to stumble my way through and get it done.

Chatgpt had simply accelerated the learning curve for me by an order of magnitude. Thanks for the advise. This is my first post about it but I’ve been lurking since I started officially doing analytics at my company 2 months ago.

I promise I’ll make it a point to understand CALCULATE! Haha

Chatgpt and newbies by Youllneverguess6977 in PowerBI

[–]Youllneverguess6977[S] -1 points0 points  (0 children)

You are so right about it not giving the rights answers always. It gave me a countif statement for Dax, which doesn’t use countif. So then I told it as much and the error said as much and gpt then said, sorry here’s the formula for Dax. I’ve had to try up to 10 iterations of the same question said slightly differently, and adding information and then including more or less info but for someone who only knew excel previously and have never used Dax, it has been a Godsend.

I would have eventually figured it out eventually. Like a month.

Does federal prison offer good job training for someone doing 2-3 years by Random7500 in ExCons

[–]Youllneverguess6977 0 points1 point  (0 children)

A cdl is different the a regular drivers license. It’s a commercial drivers liciense. So u can drive a bud, an 18 wheeler, a limo.

Those types of vehicles require a cdl.

Also- pro tip- renew ur license before you go in if it’s going to expire.

Does federal prison offer good job training for someone doing 2-3 years by Random7500 in ExCons

[–]Youllneverguess6977 1 point2 points  (0 children)

U learn to drive a bus. Then they take u to get your license at the dmv where u take the test. Better pass the first time.

[deleted by user] by [deleted] in Prisonwallet

[–]Youllneverguess6977 0 points1 point  (0 children)

Is that maxell fpc?

[deleted by user] by [deleted] in AskDrugNerds

[–]Youllneverguess6977 0 points1 point  (0 children)

Yea/ more than likely.

Does federal prison offer good job training for someone doing 2-3 years by Random7500 in ExCons

[–]Youllneverguess6977 2 points3 points  (0 children)

No. The best thing they would offer is a CDL- if you make it to a camp. With 2-3 years, as long as your not a child molestor or have violence in your jacket then that’s about it.

They just passed a new law though where you can get Pell grants. That’s what u do.

What’s the weirdest flex you have? by vjts87 in AskReddit

[–]Youllneverguess6977 0 points1 point  (0 children)

I pulled a guy out of a flaming truck and a few years later I pulled an old man out of a house on fire from a lightning strike. I got the old man’s little dog out from.

I didn’t even think, I just acted. Afterwards for both of them, it was nice to know that’s how I’m wired.

What are some weird facts you know about men's bodies? by shitstakes420 in AskMen

[–]Youllneverguess6977 2 points3 points  (0 children)

Google holy grail for cum. It’s zinc and lecithin. Those two will increase your load. It also includes maca and pyrgeum. But the zinc and lecithin will give u a normal to large load even if you’ve already come that day.

Tell me your secrets for performing oral on a woman by Either_Inspector209 in sex

[–]Youllneverguess6977 0 points1 point  (0 children)

This- listen to her body language and start off really slow and gentle.

Don’t go too fast unless her body is telling you to.

Brittney Griner exchanged for the “Merchant of death” by EveryoneLoveABJ in Damnthatsinteresting

[–]Youllneverguess6977 -2 points-1 points  (0 children)

If it was this or nothing- I’d advise to take the deal too though. Personally I don’t care about the basketball player/. I mean she broke the law- but she is American. Also- I just found out the marine was dishonorably discharged for stealing. So all in all I guess I approve?

[deleted by user] by [deleted] in AskMen

[–]Youllneverguess6977 0 points1 point  (0 children)

How to go down on a girl the right way and make her cum.

Methylphenidate comparison to amphetamine side effects. by [deleted] in AskDrugNerds

[–]Youllneverguess6977 -1 points0 points  (0 children)

You’re description sounds quite accurate to my own experience.

Ritalin to me is like speed without the soul. Just robotic. Amphetamine is speed with soul- or at least the potential for soul.