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

2 Replies

  • 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