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