Project Value between to dates

[joshua1990]

I have a simple table that shows me a value per Article

Article	Value	Date
A	1000	01.01.2021
A	1050	01.02.2021

As you can see, each value gets a new value per month.

Now I would like to fill the timeframe between both dates based on the latest value = 1000.

How can I project - using a Dax measure - the first value from 01.01.2021 until 31.01.2021?

[Jihwan_Kim]

https://www.dropbox.com/s/0mawaif2buhhv1n/joshuav3.pbix?dl=0 

[joshua1990]

Thanks, but the value should be flat based on the latest value. 

[Jihwan_Kim]

https://www.dropbox.com/s/0mawaif2buhhv1n/joshuav3.pbix?dl=0 

[amitchandak]

@joshua1990 , Create a date date table .

Create a new end date column

end date   =

minx(filter(Table, Table[Article] = earlier(Table[Article] ) &&  Table[Date] >earlier(Table[Date])),Table[Date])

rename date as start date in table 

then create a table

filter(Crossjoin (Table, Date), [Date] >=[Start Date] && [Date] <=[End Date])

A similar example in the attached file