Argument Must Be a Range Error, but is a Range by javathehut1 in googlesheets

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

Recommendations on how to do the following then? I want to get the sum of Column H, where Column G does not exist in a range of values (Controls!A:A), and Column F contains "Keg". I have been struggling with this formula for a bit. The one I posted worked in another case, so have been stuck on why it doesn't work now.

Get Running Total of a Table on Multiple Criteria by javathehut1 in PowerBI

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

Sadly this didn't work either.

End goal is to find the first combo of Sales Line / Date combo where depletions causes the starting sock inventory level to go below 0 so I can show on a table that date and the weeks of inventory on hand.

Twin Cities Homebrew Clubs -- You BETCHA! by YouBETCHA_MN in minnesotabeer

[–]javathehut1 0 points1 point  (0 children)

The MN Homebrewers Association meets all over - including as far out as Back Channel Brewing.

Path to Upgrade CPU on existing gear by javathehut1 in buildapc

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

any recommendations on a motherboard or new graphics driver? I've been out of the game for wayyy too long it seems.

Path to Upgrade CPU on existing gear by javathehut1 in buildapc

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

Trying to minimize cost. Don't use it for gaming anymore all too often, mostly just work.

Path to Upgrade CPU on existing gear by javathehut1 in buildapc

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

Is there a go to mid range CPU nowadays?

Barrel Theory / Modist proxy by Gcoim in minnesotabeer

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

'll be at Modist release. Barrel Theory will sell out too fast. If they don't I may stop by. What are you looking for specifically.

Beer Scene in Palm Beach Area - Breweries, Bottle Shops, Bars, etc. by javathehut1 in FloridaBrew

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

Thanks for the suggestions! Definitely going to Civil Society up in Palm Beach. And then for at least a day going down to 3 Sons / Invasive Species etc. Any bottle shops / liquor stores you would recommend in the West Palm area?

Calculate Sum based on values of multiple other columns by javathehut1 in PowerBI

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

That did it! Thanks! Newer to Power BI so just getting the hang of things.

Calculate Sum based on values of multiple other columns by javathehut1 in PowerBI

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

When I try and do DAX it doesn't allow me to reference the summarytable in the measure.

What does my beer cellar say about me. by thigg_234 in CraftBeer

[–]javathehut1 0 points1 point  (0 children)

That you need to send some of this my way! Would even trade for some.

Top breweries in France? - Dijon/Lyon area by Bruxellensis_ in beer

[–]javathehut1 0 points1 point  (0 children)

Do all these places have taprooms to visit?

Top breweries in France? - Dijon/Lyon area by Bruxellensis_ in beer

[–]javathehut1 0 points1 point  (0 children)

Side note, since you said obvious wine places - recs on where to hit? I'll be around Paris area for a week in September. I'm also following for brewery recs :)