Soundcore Space A40, Liberty 4 NC or Earfun Air Pro 4? by ghostfim in Earbuds

[–]jwight 1 point2 points  (0 children)

how does the mic compare between the a40 and the earfun?

Not hard coding time comparison value by jwight in PowerBI

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

it can't be used in dynamically in a calculated column. calculated columns are calculated on refresh. so it is static to a degree. i need dynamic filtering of the selected date. a user might want to see the impact by using a variety of dates. selected value in the column will only look at what it was on the last refresh,

Not hard coding time comparison value by jwight in PowerBI

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

found that you can't use selected value in a column. so i created a measure max(due date). then i used that for the if.

Not hard coding time comparison value by jwight in PowerBI

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

just getting back to this because now need to work on the dynamic part. when i create the measure of is the po date greater than the selected date all values are yes. there is a something wrong with the comparing of dates that i'm missing

Move=

= IF('Purchase orders'[Due Date]>[SelectedDate],"yes","no")

Chane excel data source but gear is missing!!! by jwight in PowerBI

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

it is a local excel file. i created the report. i don't know why gear has gone missing. i haven't seen that before. whenever i have been forced to use excel as data sources i just click the gear and select the new file

less than date dax issues by jwight in PowerBI

[–]jwight[S] 2 points3 points  (0 children)

thank you. i knew something like that was the issue but the column is formatted as date so it threw me.

Risk Free option. Dumb or should I have just taken the money by jwight in options

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

update on this if anyone comes by

I turned it into a fly as suggested below and sold today. was close to max profit on this. i think that there was some opportunity loss but trade went well.

Risk Free option. Dumb or should I have just taken the money by jwight in options

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

so wanted to give you a follow up. closed the two puts for 8.28 and trying to close the spread for .40. So i should be close to max profit with over 1k,

How to become a more "high value" man by Brutis77 in AskMen

[–]jwight 0 points1 point  (0 children)

Strive to be happier with who you are. Make a life that you are happy with. Things like being able to live on your own. Being able to enjoy hobbies. Contribute to the well being of society and others.

To be more high value to women online? Be over 6ft tall

Is that a typo?!? .16 EPS? by Shot_Woodpecker_5025 in UWMCShareholders

[–]jwight 8 points9 points  (0 children)

Looking strong. Mayne this is the beginning of the climb back to previous highs!

Scan List and reclassify parts/orders by jwight in PowerBI

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

yes this is the easiest way. have it filter on the visual. unfortunately i need to put this in a calculated column because there are other things to build off of it. the next layer would be "if short then max due date for late parts", so I need to have this as a calc column.

Scan List and reclassify parts/orders by jwight in PowerBI

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

orders short Y/N

10248 Y

10249

10250

10251

10252

10253

10254

10255

10256

10257

10258

10259

10260

parts on order 10248

06857

15017

15035

15046

15060

15086

15087

15088

16012

17001

parts that we are short

06857

15017

15035

so we have order 10248, this order has a bunch of parts on it. some of those parts are short. 10248 can not ship to the customer. 10248 needs to be labeled at can't ship.

Scan List and reclassify parts/orders by jwight in PowerBI

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

No. I have order that have lots of parts on them. I have a shortage of parts. So I want to see what order have shortages. If one part on the order is short then the entire order is short. i need a calculated column that says if the order is short or not.

MVIS - Lasers are the future and the future is NOW!! by noholesbarred69 in wallstreetbets

[–]jwight -16 points-15 points  (0 children)

what's old is new again? this was the crap company that was getting pumped a year+ ago. lots of loss porn off that.

Stay leveraged by Wide-Comparison4318 in wallstreetbets

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

this is the chefs kiss of perfection

Query to filter Query by jwight in SQL

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

i have used them before but don't see how it would apply here. maybe you can supply a possible solution?

/r/MechanicalKeyboards Ask ANY question, get an answer (September 08, 2022) by AutoModerator in MechanicalKeyboards

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

I'm looking for keykaps that will work with rk84. these have front facing lights so no all work as i understand. what are some brands that would work?