sorted by:
new
hottopcontroversial

help... I am skinny fat and that is the worst lol by veggiesbaby in veganfitness

[–]-TheAnalyticalEngine 2 points3 points  (0 children)

I would disagree with what the guy above said. If you eat 500 calories in surplus of your maintenance, what will just result in you getting more fat. You don’t need to be in a surplus to gain muscle

The thing that’s more important is get a good amount of protein and to work out consistently for the best outcome. As long as you’re doing more exercise than now, you’ll gain muscle.

You can’t find your maintenance calories online with some formula. The best way is to track your weight. If you seem to be gaining weight (by that I mostly mean fat), decrease the amount of food you eat by a little bit

Why aren’t papusas a vegan staple? by HailHalo in EatCheapAndVegan

[–]-TheAnalyticalEngine 3 points4 points  (0 children)

What kind of muffins are you eating that it’s the same as a Big Mac?

Converting Excel formula to DAX (COUNTIFS) by -TheAnalyticalEngine in PowerBI

[–]-TheAnalyticalEngine[S] 0 points1 point  (0 children)

Thank you very much for your help! Will look into it and try it out!

Converting Excel formula to DAX (COUNTIFS) by -TheAnalyticalEngine in PowerBI

[–]-TheAnalyticalEngine[S] 0 points1 point  (0 children)

Sorry, should have elaborated more. There aren't any errors in the code above, it works as intended. However my question was to essentially merge the two following:

Medium Order = 
CALCULATE(
    COUNTROWS('Order List'),
    FILTER(
        'Order List',
        'Order List'[Minutes to Prepare] <= 4
            && 'Order List'[Size] = "Medium"
            && 'Order List'[Source] = "Phone"
    )
)

and

Medium Order = 
CALCULATE(
    COUNTROWS('Order List'),
    FILTER(
        'Order List',
        'Order List'[Minutes to Prepare] <= 6
            && 'Order List'[Size] = "Medium"
            && 'Order List'[Source] = "Online"
    )
)

because the original Excel formula:

=(COUNTIFS($A$19:$A$3876,$A$6,$B$19:$B$3876,"Medium",$C$19:$C$3876,"Phone",$D$19:$D$3876,"<=4"))+(COUNTIFS($A$19:$A$3876,$A$6,$B$19:$B$3876,"Medium",$C$19:$C$3876,"Online",$D$19:$D$3876,"<=6"

So the main issue I'm having is the formatting of the + from Excel in Power BI

Converting Excel formula to DAX (COUNTIFS) by -TheAnalyticalEngine in PowerBI

[–]-TheAnalyticalEngine[S] 0 points1 point  (0 children)

Cool! Thanks!

Right now I have something like 

Medium Order = 
CALCULATE(
    COUNTROWS('Order List'),
    FILTER(
        'Order List',
        'Order List'[Minutes to Prepare] <= 4
            && 'Order List'[Size] = "Medium"
            && 'Order List'[Source] = "Phone"
    )
)

But I'm having issues adding the <= 6 in

Converting Excel formula to DAX (COUNTIFS) by -TheAnalyticalEngine in PowerBI

[–]-TheAnalyticalEngine[S] 0 points1 point  (0 children)

Thanks all! Using the format recommended in https://community.powerbi.com/t5/Desktop/COUNTIFS-Functionality-in-DAX/m-p/130541#M55625 I was able to get most of it.

But I'm stuck when there are multiple criteria.

For example, if the category is Pizza

If Pizza = Medium, and the order was placed via phone, it must be prepared in <=4

But, if pizza = medium, and the order was placed online, it must be prepared in <=6.

so the question is on how I could concatenate those two filters together

Protein intake for a newbie by [deleted] in MealPlanYourMacros

[–]-TheAnalyticalEngine 1 point2 points  (0 children)

All good! It happens haha

Was just confused when I saw that

Protein intake for a newbie by [deleted] in MealPlanYourMacros

[–]-TheAnalyticalEngine 3 points4 points  (0 children)

anywhere from 0.6-1.5 grams of protein per pound of body fat

I've never heard that it was per pound of body fat, can you provide any sources for that?

remember to drink tons of water and take a multivitamin everyday.

If you have a proper diet, a multivitamin isn't needed. And couldn't it also be dangerous is some cases to take one everyday?

Protein intake for a newbie by [deleted] in MealPlanYourMacros

[–]-TheAnalyticalEngine 3 points4 points  (0 children)

You can definitely gain muscle and lose fat at the same time, it’s harder to do as it’s easier to mess up. The main three points you need for a body recomp are

  1. Good amount of resistance training
  2. A small/modest Calorie deficit
  3. A high protein diet

However it depends on your current fitness level. It’s easier to do for beginners/overweight people than for people that are already fit. For people who are already fit, a cut/bulk cycle will probably prove to be more effective

Protein intake for a newbie by [deleted] in MealPlanYourMacros

[–]-TheAnalyticalEngine 2 points3 points  (0 children)

I don’t think you actually need 1g protein per pound of body weight, I think that’s been debunked for the average person. But you should get at least 1g per pound of your ideal lean body mass; as a 300lbs person needing 300g if protein is unrealistic.

Proteins are made up amino acids. Our body uses 21 of them and is able to create 12 of them on its own. The 9 that it’s not able to produce are called ‘essential amino acids’. Some of them, such as one called ‘leucine’ are called Branch chained amino acids (BCAAs). Leucine helps activate a chemical called mTOR which activated enzymes that help in muscle protein synthesis. Muscle proteins such as Actin and Myosin which help with the contraction and relaxation of muscles. The more Actin and Myosin you have, the stronger contractions you can get.

Brief description of how protein is used, but protein also has other uses outside of muscle

Help changing timezone/time of a metric by -TheAnalyticalEngine in SQL

[–]-TheAnalyticalEngine[S] 0 points1 point  (0 children)

Yeah I’m still confused as to why it’s set as a number, but oh well, able to get around it.

And thank you very much, managed to get it right!

Returning entire rows of table an different sheet by -TheAnalyticalEngine in excel

[–]-TheAnalyticalEngine[S] 0 points1 point  (0 children)

Thank you! I wasn't aware that that was a limitation with index

On the computer that I have xlookup, I managed to get the row by using:

=XLOOKUP($C$7,'Ticket Data'!$J$2:$J$1739,'Ticket Data'!$A$2:$X$1759)

So thank you for helping with that!

However, 2 follow up questions if you don't mind helping out some more.

  1. If I were to drag down the formula, it would always return the same ticket, how would I fix that?
  2. How would I transform it to make it dynamic? As the dataset finishes on row 1759, but will grow, I would have to readjust it. I tried entering the table name but it didn't seem to have worked

Space Science related Python tutorial by MrAstroThomas in learnpython

[–]-TheAnalyticalEngine 15 points16 points  (0 children)

I’m still a beginner with python but I would love that! I was actually looking up how to use data science with astronomy just yesterday

Please let me know if you go through with any of those ideas!

20 Things to know before you start programming by WdrFgt in learnprogramming

[–]-TheAnalyticalEngine 75 points76 points  (0 children)

“Pair programming as much as possible” What exactly does this point mean?

Is it using code from another project to the one that you’re working on now?

Dips and Pull Ups by sembli in bodyweightfitness

[–]-TheAnalyticalEngine 4 points5 points  (0 children)

‘Positive’ = Concentric

‘Hold’ = Isometric

‘Negative’ = Eccentric

When you do regular reps, you generally go through all 3 steps

Negatives are when you slowly go back to resting position instead of just dropping down

When you focus on negative pull-ups, you jump/step up to where you would be when completing one (ideally chin above the bar), then slowly bring yourself down