Calculated measure to fill in blank values from previous populated row for a given date range

[Anonymous]

Hi,

I have reached my DAX knowledge limit so without wasting more time, I'd like to see if someone solved the same or simlar measure.

Requirement:

I have an Event table (lets say Table1) and a Calendar table (Table2). I'd like to create a measure in Table1 that will populate the allocation for all blank dates in Table2 up until an allocation value changes. Picture a matrix visual... Drag the Id of Table1 and Date of Table2 in rows and the new [allocation measure] in values. Below is the desired result.

I tried some MIN date MAX date GROUP BY Id measures but either it's not possible or I'm not approaching this correct.

Any options/solutions for this?

Thanks,

J

[lbendlin]

MAXX or LASTNONBLANKVALUE or similar should work for that.

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.