Forum Discussion

hpatel24779's avatar
hpatel24779
Icon for Helper II rankHelper II
1 year ago

identifying 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 ...
Need Help
Show and Tell
Tips and Tricks
hpatel24779's avatar
hpatel24779
Icon for Helper II rankHelper II
1 year ago

hi 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's avatar
p45cal
Icon for Solution Supplier rankSolution Supplier
1 year ago

re: "how can i apply the same method in Power BI query?"

I'm ashamed to say 'I don't know'. Power BI is something I've only just begun to explore and my attempts at this would probably be very amateurish. Maybe someone seeing this thread would know how to adapt my solution.

I did try Yolo's query on your bigger data, primarily to compare results, and 55 minutes later it's still:

 

 

although my machine is 9 years old.

Does your data reach Power BI via Excel or in some other way?