Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
kenblack
Helper I
Helper I

desktop

I have 2 columns start and stop I want to count the number of start stop events according to the following rules 

counting starts when first discharge occurs

• any start in the first 12 hour block is counted as 1 event

• any new start in the next and subsequent 24 hour blocks are each counted as 1 additional event

• this counting continues until there is a 24 hour block with no event.

• for the next event after 24 hour block with no event, the sequence begins again

Could anyone help me please

 

Thank you in advance

11 REPLIES 11
v-juanli-msft
Community Support
Community Support

Hi @kenblack 

Besides, i will give an example, please help me to understand your requirements:

Capture4.JPG

Please correct me if i misunderstand something.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@kenblack , You can get diff with min date time of block and use that to get id

diff with min date time block

new col= datediff( minx(filter(Table, [block] =earlier([block]) ),[date time]),[date time],hours)

Pragati11
Super User
Super User

Hi @kenblack ,

 

Can you please share some sample data to suggest a solutions for your query?

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi @kenblack 

My account has no aceess yo your file.

It is not recommended to share personal files/data into one drive personal.

If your file contains important and privacy data, please remove it.

 

Best Regards

Maggie

Hello Pragati 11 sorry to be a pain but i have tried to see how I can share a sample with you would you mind guiding me through that as well

 

Really sorry but thank you

Hi @kenblack 

You could upload a excel file to one drive for bussiness, then share the url with us.

It is better to make the a small sample with expected result.

 

Best Regards

Maggie

@kenblack you can share using one drive/google drive.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.