Create a new table from an existing table by splitting a column by dates using DAX

[314mp_M0th4]

Hello. I have some data in power BI representing tasks. 

Task	Start date	End date	Progress
Get data	1.1.2023	31.5.2023	25%
Create visuals	1.3.2023	31.6.2023	0%

The idea is to split each year into 3 parts and make a gantt chart for the tasks. However, if a task spans multiple parts it must be split into different task for each part. The progress must also be calculated seperatly for each part the task is in. Any ideas how this might be done with DAX?

Thanks in advance.

[lbendlin]

Not enough sample data to work with. You would also need to assume linear progress over time. That's not what happens in real life.

[314mp_M0th4]

Lets say each period id 4 months, so period one ends in april. A task may start in january and finish in june so the goal is to split it into two tasks, one that spans period 1 and another that is from may to june. So only one data point should be fine. But I guess one could ask the project managers to do this manually as its not a lot of work.