Forum Discussion
Solved
Splitting overlapping dates using Power Query
I have the below table: Start Date of Contract End Date of Contract Contract 1/7/2019 31/8/2019 X 1/9/2019 31/3/2020 X 12/5/2020 31/12/2021 X 1/4/2017 31/3/2018 Y 1/4/...
Hi
this is done in my solution here: https://community.powerbi.com/t5/Desktop/Need-urgent-help-DAX-calculation/m-p/1216539#M541668
(Assuming there is an error in the first row of the sample you've provided and it ends end of August and not end of year:
Start Date of Contract End Date of Contract Contract 1/7/2019 31/08/2019 X 1/9/2019 31/12/2019 X 1/1/2020 31/3/2020 X 12/5/2020 31/12/2020 X 1/1/2021 31/12/2021 X
Anonymous your solution seems to be correct. This is exactly what I want. I made a mistake in the first row as indicated by ImkeF
ok.
I take this opportunity, just to make an observation and ask for comments.
The point concerns the use of the Date.EndOfYear function which seems to accept only DateTime type arguments and not Date.
For this reason in the spliRow function I have done back and forth dateTime.From and dateFrom.