Forum Discussion
hpatel24779
Helper II
Helper IIidentifying continuous dates per person in new column
Hi All, I want to firstly thank all members that have helped with my queries so far and hope to continue getting support which will help me improve on my Power BI skills. My latest query is ...
hpatel24779Helper II
Helper IIhi p45cal,
this works perfectly in excel - how can i apply the same method in Power BI query? i don't know how to get the MinGap in my model
p45cal
Solution Supplier
Solution SupplierIn the linked-to pbix file below is my offering.
Note that your columns are not the same as your original request (Client ID has become Person Id, and there is no Service column) so I've had to re-write the query a bit.
The pbix file links directly to your dropbox file, so don't change your dropbox file until you've changed the source in the pbix file.
Regarding MinGap, I've added that instead as a step in the query which you can edit easily:
Link: https://app.box.com/s/pzc1ewxh4xc5z8q7barwgtjon13cz2bm