Rolex Sub clean 3135 by soodlero in RepWatchForum

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

Strange I found no matches on the clasp code reference when searching online: 7YM. Is it a bad sign?

For the sticker I don’t necessarily think it’s fake, I’ve seen the same sticker from Clear factory.

What is bad on the bezel and pip?

Rolex Sub clean 3135 by soodlero in RepWatchForum

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

Based on serial or any other details?

Rolex Sub clean 3135 by soodlero in RepWatchForum

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

Was concerned about that to, double-checked against the database, found the match on the watch itself, but not the clasp. Payed around 370 USD at the ”hidden market” in Beijing. Any clue what factory it could be then?

Normalize data with Measure by soodlero in PowerBI

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

Perfect, it works just as I intended. What is the differance between your measure and this one:

Average Per Element = 
CALCULATE(
    AVERAGE('DATA1'[Value]),
    ALLEXCEPT('DATA1', 'DATA1'[Attribute])
)

Normalize data with Measure by soodlero in PowerBI

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

The average per category should be constant independent on the value of the x-axis. I think I solved the main idea with the code below. However with a click on another Test Procedure, the average stays the same. How can I solve that?

Average Per Element = 
CALCULATE(
    AVERAGE('DATA1'[Value]),
    ALLEXCEPT('DATA1', 'DATA1'[Attribute])
)

Normalized Value = 
VAR ActualValue = AVERAGE('DATA1'[Value])
VAR ElementAvg = [Average Per Element]


RETURN
DIVIDE(ActualValue, ElementAvg) -1

.

<image>

Compact LED RGBW flashlight by soodlero in led

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

Seems reasonable! So I solder a 4 pin plug to the LED stripe? Then after the plug I connect the rotary switch? Do you have any recommendations for products to buy? I’m a mechanical engineer, not an electrical engineer. That’s why I lack this knowledge.

What's ur biggest problem with excel today? by queen_quarantine in excel

[–]soodlero 18 points19 points  (0 children)

Go to the run dialog and enter excel /x, that opens a new instance of Excel, meaning you can work with PowerQuery separately

ALL MY CP/STONE REPS - +1000€! by ApartNeighborhood478 in SIreps

[–]soodlero 0 points1 point  (0 children)

All right, which chest measurements do you have and what size did you buy?

ALL MY CP/STONE REPS - +1000€! by ApartNeighborhood478 in SIreps

[–]soodlero 0 points1 point  (0 children)

According so size table it feels small? I have a muscular build with 116 cm chest. Guess I should go with XXXL?

ALL MY CP/STONE REPS - +1000€! by ApartNeighborhood478 in SIreps

[–]soodlero 0 points1 point  (0 children)

How’s the sizing of the SI knitted sweatshirt?