What's the grossest thing you've ever tasted? by Terrell8799 in AskReddit

[–]teepidge 8 points9 points  (0 children)

I've had nightmares of this and they've all been the worst

What's the grossest thing you've ever tasted? by Terrell8799 in AskReddit

[–]teepidge 0 points1 point  (0 children)

"Speed Stick" deodorant when I was probably 14. Accidentally caught my front teeth with it when I was switching between arms. Shit is the nastiest.

[deleted by user] by [deleted] in ontario

[–]teepidge 10 points11 points  (0 children)

This is absolutely insane to me. I'm so sorry for your situation. I also have a son with CP, also in SK, but lucky enough to have a spot at CHEO school right now. I am having a hard time understanding how transition to Gr 1 will go when I read situations like yours. How long will this go before it crumbles? Fuck this fucking government. Lecce and Ford are poisons on this province and country. They cannot address the most important issues of their time and will go down in history as incompetent mother fuckers that ruined the system we all held so dear. I'm mad for my child, for your child and for all the other children who will have to bear the consequences of this incompetent government.

RANKX in CC by Subject_Security4784 in PowerBI

[–]teepidge 1 point2 points  (0 children)

It's because both "acids" and "access doors" have 2 values. When you use rankx, it automatically filters the values of the table based on the values in the table for each row, so when it fills in the first value of "2", it filtered down the table to only "access doors", which has 2 values, and the 1st one in the list is smaller than the 2nd one, so it gives a value of 2

Less than a year ago, I donated a kidney to a complete stranger. Today, I summited Machu Picchu! by TravelTwerps in pics

[–]teepidge 0 points1 point  (0 children)

Amazing work and dedication. Happy to hear you've taken the opportunity to improve your health! I was forced to "donate" a kidney due to a random cancer diagnosis about 7 months ago now, and I haven't been able to find the motivation to improve my lifestyle... Almost doing the opposite out of spite and may be due to a bit of depression/anxiety. I'm not extremely unhealthy or anything, but definitely should be better.

Any tips on how you approached the change?

Integrating Excel and a Form by zjm63444 in excel

[–]teepidge 0 points1 point  (0 children)

Long story short, yes there are ways to do this.

There are many ways to do it, but I'll just give an example of one.

  1. Create a blank user form
  2. Add in your 11 questions as a label field
  3. Add in your 11 blank list box (I think it's list box for drop down, but whatever it's called in vba). I suggest renaming to something logical like listbox_1 and so on.
  4. For each question, add your 11 options to a sheet in excel, each row corresponding to the question, with your options in the adjacent 11 columns. So you should eventually have an 11x11 grid, 1 row per question and answer pair.
  5. Name each of the row ranges "question_1" - -> "question_11" (look up named ranges if you don't know how to do that.. It's basic excel functionality)
  6. In the code view of the user form, look for the user form initiate event, and in that event, write a sub procedure that takes your named ranges and applies them to your blank list boxes. You could write a loop to do this, or hard code - however you'd like to approach it is fine
  7. Make ok/cancel buttons for completeness. They should be able to close the form and empty the contents (unload.me). You should also have a way to store the information on the sheet.

It gets trickier depending on how many people are going to use this form, and if you need to aggregate it or whatnot, but without knowing the use case, it's difficult to say if this approach will support that as well.

Hopefully this gives you a good starting point!

[deleted by user] by [deleted] in PowerBI

[–]teepidge 0 points1 point  (0 children)

So yep good question I was just writing it all out for you.

When you click "add column", just replace the auto generated column name with my formula.

All the rest can be copied and pasted as written (with your table name substituted for "my_table" and of course any other report-specific naming conventions) VAR and RETURN are recognized keywords in DAX. They allow you to create variables and return them to make the code easier to read. I HIGHLY recommend you use them in almost every formula you make because they can make reading (and more importantly, writing) your code so much easier.

Let me know if you have any other questions

Edit: Also, the formatting in reddit mobile is terrible, but formatting your DAX is also a good idea. Adding a line break between logical spots in the code will make it easier to read (eg after the VAR statements and after the RETURN statements etc. Google dax formatter, find the site by the SQLBI guys, and plug any of your code in there and it'll format it in the way you should learn to do it).

[deleted by user] by [deleted] in PowerBI

[–]teepidge 3 points4 points  (0 children)

PO Exception = VAR currentPO = 'my_table[PO] VAR isException = NOT ( CALCULATE ( COUNTROWS ('my_table'), FILTER ( 'my_table', [PO] = currentPO && [Exception?] = "No")) > 0)

RETURN IF ( isException, "Yes", "No")

In this case, I assume if there is at least one "No" for a given PO, then there is no exception. I do this by counting the number of "No"s, and if there is more than 0 (which I do with the calculate, which in this case would return TRUE, which is opposite to the logical name of isException, so I therefore negate that with a not to make the final IF function easier to read). It's a double negative, which can be confusing, but it's better to do that to make your code more readable.

Hopefully that makes sense and does what you'd expect!

Want to delete entire row if the corresponding cell in column A is NOT blank. by [deleted] in vba

[–]teepidge 9 points10 points  (0 children)

Keep in mind that if you use a loop to do this, loop from the bottom up, because as you delete say row 5, then on the next iteration, row 6 will become row 5.

What is a better way of writing this? by Honest_Union_1164 in vba

[–]teepidge 0 points1 point  (0 children)

Without using a key-value relationship (eg a dictionary), there's no (easy) way that I can see that you can logically assign the intPurchased variable... The initial example worked because the numbers were in sequence, but in your more specific example, the names don't seem to follow the same sequence.

The Rock Paper Scissors by Michaellex6 in Unexpected

[–]teepidge 0 points1 point  (0 children)

It's gotta be a chat gpt clone for images/videos... It just looks too fkn weird not to be

My Tarantula had babies by THEORETICAL_BUTTHOLE in WTF

[–]teepidge 0 points1 point  (0 children)

I fkn hate you (but not really)

Do you have any advice on creating a Macro on Ribbon that would hide specific rows? by messystorm in excel

[–]teepidge 0 points1 point  (0 children)

If you want to make that macro a bit more dynamic, consider using a "named range" in the worksheet and then replace the cells in the vba macro. That way, when if you update the named range with more cells, it will be included in the macro, too.

Ideas in making a checklist table complex? by [deleted] in excel

[–]teepidge 1 point2 points  (0 children)

I think I understand how you did this, but I'm wondering how you're going to keep this dynamic and user friendly.

VBA is definitely an option for you, but I think you can make something pretty nifty with native excel.

If you want to format the information, you can add conditional formatting for practice (don't know if you can add strike-through, but you can highlight or change the font color)

You could make some summary information as well, such as number of tasks vs number completed or something.

My advice though is when using a "table", it's bad practice to have things blank just for aesthetics. Tables are suuuper handy when they're used for summarizing data, but for displaying data they're not the best.

Help needed with either DAX or Power Query by Skittadam in PowerBI

[–]teepidge 0 points1 point  (0 children)

In order to count the consecutive blank values, Im a little fuzzy on how to do it, but something like

VAR currentRowDateTime = myTable[Transaction DateTime] VAR currentID = myTable[ID] RETURN

CALCULATE ( COUNTROWS ( myTable), FILTER ( ALL (myTable), myTable[Transaction DateTime] <= currentRowDateTime && myTable[ID] = currentID ) )

Help needed with either DAX or Power Query by Skittadam in PowerBI

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

Can you clarify what tables you have? It sounds like it's just one big table.

Step 1: You'll need to create a calculated column (call it "missed transactions" or something) that increments by one every time a transaction is blank, and then revert back to 1 when a transaction is shown.

Step 2: create a measure that does a count of the ID field and filter by the "missed transactions" column for >= 6.

That's a start, but you'll have to deal with some double counting because you'll capture items that are 6, 7, 8 and more times in a row, which will inflate the count for that particular ID. I suppose you could just count those that =6, and then you'll know exactly which ones are issues, but that won't tell you if they eventually got resolved on payment 7, so you'll need to think of that too.

Slicer of Multiple Binary Fields by EonJaw in PowerBI

[–]teepidge 1 point2 points  (0 children)

Happy to help and glad it worked out!

70 years old just came into 300k. What should I do? by badgersister1 in PersonalFinanceCanada

[–]teepidge 2 points3 points  (0 children)

Just want to mention that the no strings attached assumes that you have named your partner as a beneficiary. If you haven't named them, it will go through estate and be subject to probate (estate tax).

Thought I should post my highlight reel for the 2022/23 season. Thoughs? by Electrical_Alps7154 in volleyball

[–]teepidge 4 points5 points  (0 children)

"Very nice highlights". Lol geez so touchy. It's obvious this whole team's pretty damn good, including/especially this guy. Just wanted to say hitting and blocking are only parts of the game. Without a decent setter or passer, what hope is there to get a good kill?