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 1 year, 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 1 year, 11 months ago by  pietlinden.
• This reply was modified 1 year, 11 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. =)

Please provide DDL & sample input data, & show the expected results vs. the actual results

How about a CREATE TABLE and INSERT scripts so we have actual data and not...

Create a stored procedure that creates and uses all the temp tables you want. Then at the end return records from your temp tables.

In PowerBI, Get Data -> From SQL...

• This reply was modified 1 year, 12 months ago by  pietlinden.
• This reply was modified 1 year, 11 months ago by  pietlinden.
• This reply was modified 1 year, 11 months ago by  pietlinden.

Is this a DAX question? DAX answers are super weird, because the language is strange (from a SQL perspective). But super easy in DAX.

=DIVIDE (

COUNTROWS('Table1'),

CALCULATE(

COUNTROWS('Table1'),

ALL('table1')

)

)

haven't done this in SSRS in...

I need to join the second table sorted by dt_mev descending order, so that the first linked row will be the latest record on table 2.

Don't use INNER/OUTER JOIN. use...

In other words, once you've connected, it's pretty much the same as working with a SQL Server database?

If I can execute a stored procedure in PostGreSQL, I assume I can...