Divided We Stand: The SQL of Relational Division - Simple Talk (red-gate.com)

Read the article... that's how you do it in T-SQL. In DAX, well, that's a whole other kettle...

Something like this?

SELECT CustNo, TimeAmount AS Amount, 1 AS ExpenseType FROM #P
UNION ALL
SELECT CustNo, ExpenseAmount, 2 FROM #P;

.NET?

Which pages??? The first N records per parent? What does "a certain number" mean?

Could you give us a quick example?

wow. for that many points, that's a pretty terrible description.

For starters, here's your code fixed up a little:

use tempdb;
GO
CREATE TABLE ReportingPeriods(
StartDate DATE NOT NULL,
EndDate DATE NOT NULL,
PeriodID...

This sounds like it's supposed to be done in PowerBI, using DAX. Doesn't sound like a SQL question at all.

DDL = Data Definition Language (CREATE TABLE scripts, [INSERT] scripts, so we have data to work with).

you can see your data, but we can't. So we need some sample data...

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

Is this a DAX question or a T-SQL question?

Joe Celko wrote an article showing how to do this in T-SQL. I think the gist of it is that you count...

Here's a beautiful screenshot of my table!

<ducking>

Me too. It's weird, but I find the act of writing (not typing) helps me remember better. And I doodle to make sense of and plan things (like my terrible...

Are you trying to put all of this stuff into a single fact table? Don't. Hiring/Turnover is one table, Sales etc is another. They share a Time/Date dimension, so summarize...

What you're describing in a roundabout way is a tabular model using DAX. So there are two things you need to get your head around to do this: DAX and...

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

Are you trying to return the first non-null value?

COALESCE()?

Say I have a slowly changing dimension for my Ingredients

(IngredientKey, IngredientAK, Name, UnitPrice, WeightInKg, Weight, StartDate, EndDate)

The part that's messing me up is that I can't reallly join RecipeIngredients(ProductKey, IngredientKey,...

Don't attach it. Just copy it and paste it into your message.  Make life easy on people here. =)