Data Modeling Issue

[jfeddes]

Here is my predicament:

I have multiple sources that fresh on a monthly basis (bring in data and associated year-month dating).

However, some sources are only updated on the "rare occasion" (say quarterly on average).

SO, when I go to combine the sources, it looks like the data from the "rare ocassion" table is missing for months it wasn't refreshed in.

See below table for example:

Now, if I have a date slicer from my calendar table, select feb-23, agent will appear blank.

I don't want it to be blank, but rather, I want the most recent agent date applied backwards until a "new agent" is later updated.

Does this make sense?

[lbendlin · Accepted solution]

Read about "Fill Down/Up" in Power Query.  Or use measures that handle the required logic.