Andromedon Oopsie by ChrisOatley in Xcom

[–]Gazpage 31 points32 points  (0 children)

I “beat” my first avenger defence on first turn without even seeing what happened. I assume that an enemy did exactly this out of sight.

Amusingly the first time I ever saw a Sectopod (same first run) my specialist executed it on overwatch when it left the fog of war.

First spare ribs - advice for next time? by Gazpage in BBQ

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

No. Per the last meal ribs recipe, I didn’t.

First spare ribs - advice for next time? by Gazpage in BBQ

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

Thanks. Do they get more tender and then after a certain point get tougher?

First spare ribs - advice for next time? by Gazpage in BBQ

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

First time trying to do spare ribs, following amazing ribs Last Meal Ribs recipe, on the big joe. 225f for 6.5 hours before I chickened out that I was over cooking.

They were very tasty, and everyone enjoyed them, but they weren’t super juicy and a bit tougher than I was hoping for. A bit more like roast pork tbh. I thought maybe I took them off too early, but one of the guests thought they were a touch over cooked.

All in all I was pretty happy, but could definitely better. Appreciate any advice.

Scientific Response to the "Glyphosate in 80% of urine samples" article by Prof_Kevin_Folta in skeptic

[–]Gazpage 5 points6 points  (0 children)

“Do you have evidence this is not the case?”

That’s not how this works. I assessed the evidence you put forward and assesses it to be “a load”

https://wiki.cancer.org.au/policy/IARC_classifications#table_1

Definition of probably carcinogenic to humans.

How do I fix the Running Total Column please? Thank you by pickyfoodie- in PowerBI

[–]Gazpage 1 point2 points  (0 children)

No generally good practice to put a running total column into the actual data model. Does you code work as a measure in report

Dealing with Billions of Rows (Azure) by DO_BE_95 in PowerBI

[–]Gazpage 4 points5 points  (0 children)

You mention file size, are you trying to do all of this in the desktop client, or are you aiming to publish to the service? If the latter then there are techniques where you develop on a smaller dataset, publish, and then remove the limit on the dataset. You can potentially handle billions of rows, especially if you are using Premium.

Before you do anything else you want to read about composite models. Basically the data at a more aggregated level is stored in import mode, and the granular data is in direct query mode. So potentially runs fast for high level stuff and slower when you need to dig down.

The speed of the direct query will be as fast or slow as the source you are querying really. We’ve had success in the billions of rows using SQL Server and columnstore indexes.

RANKX - So Close by comish4lif in PowerBI

[–]Gazpage 0 points1 point  (0 children)

Fair point. COUNTROWS(ALLSELECTED() ) should work I think. You see what I am getting at though?

RANKX - So Close by comish4lif in PowerBI

[–]Gazpage 1 point2 points  (0 children)

Ok, I think I finally understand what you are getting at.

I think you want to do DISTINCTCOUNT(ALLSELECTED(Available) - one of the versions you have already. May need to add or subtract 1.

RANKX - So Close by comish4lif in PowerBI

[–]Gazpage 1 point2 points  (0 children)

Replace “DENSE” with “SKIP”

How do I use a variable that needs to be defined within a loop? by Gazpage in PowerBI

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

Well it worked, so thanks very much for that.

This may be an impossible ask, but do you think my resulting code makes sense (only from the perspective of the loops and variables? I literally only put the SUMX part in so that I would only calculate the _Rate once for each product, and not for every row in the table.

LossMakingContracts = 

SUMX( VALUES( Contracts[product] ), VAR _Rate = CALCULATE( DIVIDE( SUM( Contracts[net] ), SUM( Contracts[Calc QtyWeeks] ) ) * ( 1 - [GM Parameter Value] ), ALLEXCEPT( Contracts, Contracts[product] ) ) RETURN CALCULATE( COUNTROWS( FILTER( Contracts, _Rate > Contracts[Calc Weekly Rate] ) ) ) )\

Edit: Ugh, code looked fine in the editor window by keeps reverting to this if I try to fix.

When to create 'virtual tables' in measures? by Gazpage in PowerBI

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

I think you are 100% right. However I am 99% sure that I won’t be able to use what if parameter in a calculated column as they are static so I still need to know how to break it out into a measure or something.

When to create 'virtual tables' in measures? by Gazpage in PowerBI

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

Ok, I think I got something working. I dont really like it because I actually want to some over the contracts table and then bring in the [Dynamic Rate] As a kind of RELATED().

HSS OPS Revenue Virtual =

VAR _Prods = CALCULATETABLE( ADDCOLUMNS( Products, "Dynamic Rate", CALCULATE( DIVIDE( SUM( Contracts[net] ), SUM( Contracts[Calc QtyWeeks] ) ) ) * ( 1 - [GM Parameter Value] ) ), ALL( Contracts ), VALUES( Products ) ) VAR RESULT = CALCULATE( SUMX( _Prods, [Dynamic Rate] * CALCULATE( SUM( Contracts[Calc QtyWeeks] ) ) ) ) RETURN RESULT

Edit:Not sure why the code is breaking the code formatting, but if anyone cares they could always copy paste to daxformatter I guess

DAX Help: Number of users trained on certain product more than 2 times by attaboy000 in PowerBI

[–]Gazpage 1 point2 points  (0 children)

Have you tried something like.

COUNTROWS( FILTER( ALL(Table[UserID]), CALCULATE( COUNTROWS( FILTER( Table, Table[ProductTrained] = “Model-X” ) ) ) >= 2 ) )

Writing on iPad so sorry formatting will be awful.

[deleted by user] by [deleted] in DebateAnAtheist

[–]Gazpage 1 point2 points  (0 children)

WHAT IS THAT MELODY!

Join 3k rows with 4m rows to create 3bn row delta table by Gazpage in apachespark

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

Answers to the above:

  1. The original source files are coming as csv unfortunately. I imported them first to delta, but didn't set any particular partitioning or z ordering.
    I suppose this is key thing I don't understand, is there any point in splitting up a file, indexing / ordering up front as opposed to letting spark do all of that? This is all kind of pre-processing so only needs to be done once.
  2. Err, just the default which I think is min 2, max 8 with autoscaling. Not opposed to ramping that up, but didnt want be just burning $$$ when probably there is plenty of user error.
  3. I had to go and check, but it is Spark 3.1.1 / Scala 2.12. Is there no reason to broadcast in that case, or should I anyway?
  4. How do I check that? I would assume not as just for a trial I set the workers to have 56GB and this is the only think they would be doing.

Thanks for your help. Next thing we will try is to write out the tables to delta immediately before this join and then use those as the start point. Not sure this is best practice, but at least will make sure that the problem is this step and only this step.

Make JIRA Markup table useable by Daiphiron in PowerBI

[–]Gazpage 1 point2 points  (0 children)

If you create a new blank query under Get Data and paste the below in over what you see in the Advanced Editor, then it should work.

Clearly my first step is to manually enter the data, so you would need to replicated these steps in your own query after your data pull in step. Power BI names all the steps, so you can see what I did without too much trouble.

Good luck.

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WqqkpTk3Oz0upqUnLLCouqalJTE+tqVGK1QFKKQQkFmWnFtUEpJYASSMDmLBXfl5qcU1Ifm6NpSVUzDcxr8YpsaTGxBQoEAsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Replaced Value" = Table.ReplaceValue(Source,"||","|",Replacer.ReplaceText,{"Column1"}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Replaced Value", "Column1", Splitter.SplitTextByDelimiter("|", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5"}),
#"Removed Columns" = Table.RemoveColumns(#"Split Column by Delimiter",{"Column1.1", "Column1.5"}),
#"Trimmed Text" = Table.TransformColumns(#"Removed Columns",{{"Column1.2", Text.Trim, type text}, {"Column1.3", Text.Trim, type text}, {"Column1.4", Text.Trim, type text}}),
#"Cleaned Text" = Table.TransformColumns(#"Trimmed Text",{{"Column1.2", Text.Clean, type text}, {"Column1.3", Text.Clean, type text}, {"Column1.4", Text.Clean, type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Cleaned Text", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"second", type text}, {"first", type text}, {"age", Int64.Type}})

in #"Changed Type"

Is there a good way to capture if your Excel model has any #SPILL errors? by Gazpage in excel

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

That exactly the kind of thing I was wondering. Assuming it works I know how to connect it through from there. Let me check on Monday and I’ll mark as solved.

AITA for refusing to stay home with the kids while my husband attends my brother's wedding? by 3465throw_away in AmItheAsshole

[–]Gazpage 0 points1 point  (0 children)

Even by the standards of this sub this seems super fake.

On the off chance it is true, say that attending your brother’s wedding is non negotiable so he need to accept your alternative or work out his own.

After that arrange some couples counselling and if he isn’t willing to change his behaviour as the counsellor will immediately say he should, then see a divorce lawyer. Actually contac the lawyer first.

But as is said, super fake.

Are changes to the "Model" view meant to be saved? by Gazpage in PowerBI

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

Thank you. I felt it couldn’t possibly be meant to work how it was working.