Oh, sorry. Left a lot of stuff out.  The files are getting imported into PowerBI (not in Fabric, or whatever MSFT calls it these days), and they do all the...

• This reply was modified 2 years ago by pietlinden.

Okay, silly me... I completely missed Reza Rad's video on it, "Aggregation to speed up the performance of a Power BI report even if all IMPORTED"

You basically create an...

if all else fails, read the manual:

pandas.DataFrame.mean — pandas 2.1.1 documentation (pydata.org)

In particular, the diagnosis and procedure dimensions could be handled as a multi-valued dimension

How do you mean? Could you give an example of "a diagnosis being handled as a multi-valued...

If you're going to do lots of date-related analysis, I'd just create a Calendar table with all the columns you want to group by, and then join to that in...

Can't see your data. Without that, I'm pretty sure we can't do anything. Could you post at least some representative data? (CREATE TABLE and INSERT scripts, not pictures =) )

Never mind. I'm a knucklehead. Bring in all the tables (seems I shouldn't have to?), filter by name, expand tables, append.  "Use the force, Luke!"

• This reply was modified 2 years, 4 months ago by pietlinden.

Why do you want to partition the table? Partitioning a table is for speeding up backup, not speeding up your queries.

(Where's the "SQL Howlers" article that Gail Shaw wrote about...

Use ROW_NUMBER() OVER (PARTITION BY<field list> ORDER BY <field>) where the columns in the PARTITION BY section are the columns you would use to determine uniqueness.

Standard way to do this...

• This reply was modified 2 years, 4 months ago by pietlinden.

You have to sum first, and then use LAG on that result to get what you want... like this... Oh, and since you're new, I created tables for you etc....

are you using Tabular or Multi-dimensional?

in tabular, you don't need a separate date table. Just use ALL() to remove whatever filters you want from the evaluation context.

Are you attempting to restore over the top of another database? (Did you change the name of the database you're restoring? You should have). Once you do that, you can...

"But in this case the business is using Access managing their own Access db. So looking for same functionality but with a SQL Server. Please advise? Thanks in Advance!"

Maybe I...

Could you use EXISTS () with a correlated subquery instead of APPLY? (or is that just brutally slow?)

a generic recipe is something like this:

CREATE TABLE Recipe (

FinalProductID INT NOT NULL,

IngredientID INT NOT NULL,

Quantity INT NOT NULL CHECK (Quantity>0)

CONSTRAINT pkRecipe PRIMARY KEY (FinalProductID, IngredientID)

);

The "amount" output is the...