Forum Discussion

lua2's avatar
lua2
Frequent Visitor
3 years ago

Create lines between period

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  
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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's avatar
lua2
Frequent Visitor
3 years ago

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