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, 11 months ago by pietlinden.
• This reply was modified 2 years, 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 2 years, 12 months ago by pietlinden.
• This reply was modified 2 years, 11 months ago by pietlinden.
• This reply was modified 2 years, 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...

sample data = CREATE TABLE and INSERT scripts, so we have a table of data to work with.  Or maybe you really don't want any help?

Sorry, been doing other things for a while... =)

That's kinda what I was thinking. Using FILTER() to return a table of Ingredient Price records that are "active" for the given...

I would think you should either split the date / time column into two columns  - one with just the date and the other with just the time, or use...

where's your multi-valued parameter defined? In the stored procedure or in the report? I would try using IN() with the report multi-valued parameter and see if that fixes it.

Did you see this?

Using Recursion and Date Tables to Simplify Date Logic

then you'd just filter it down (inside the CTE) so that it only returns Mondays.

Are your results already in a table?

Sounds like these are all separate questions... Could you post a script that creates and populates a table with your sample data?