Forum Discussion
Kolumam
Post Prodigy
Post ProdigySplitting 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
Smauro
Solution Sage
Solution SageCould you explain why you'd like to see the second row in your result?