Create lines between period

[lua2]

Hello,

I have milestones in a table with a start date, but I am missing the time periods in between. How can I create these rows in between? 

thanks and kind regards

[amitchandak]

@lua2 , Try a new column

Var _max = maxx(filter(Table, [Projectid] = earlier([projectid]) && [milestoneid] = earlier([milestoneid]) && [milestonedate]< earlier([milestonedate]) ), [milestonedate])

return

datediff([milestonedate], _date, day)

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

[lua2]

Hello @amitchandak, 

thank you very much for your advice. But later I want to connect it with another table. In the other table, the records are recorded per day, so if there is a record with the day 20.03.22, it will be assigned with no milestone. Then in the report it should be filtered based on the months. Would you have another idea how I can proceed here?

Thanks in advance and kind regards