Forum Discussion

LéaGr's avatar
LéaGr
Helper I
6 years ago

PowerQuery : clean data so time intervals do not overlap

Hi guys!   I need some help solving an issue on PowerBI/Powerquery. I need to clean data and I can't work directly into the datasource so it must be done with Powerquery. Basically I have several t...
Need Help
Tutorial Requests
LéaGr's avatar
LéaGr
Helper I
6 years ago

Hi amitchandak ,

 

Thanks a lot for the answer.

It helps as it allows me to identify the overlaps but I still do not know how to clean them. Would you know a way to replace the end date of an event in conflict with another by the start date of this other event for example?

 

Thanks a lot,

Best,

 

Léa