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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
nicolasvargas
Helper I
Helper I

Calculated Column identify cases between two dates

Hello,

 

I have a database with the following structure:

 

IDIn PointOut PointDesired Column
A000
A101
A001
A011
A000
B101
B011
B000
B101
B011

 

I have on data base the entry point (IN POINT) since which I would like to filter a specific ID and an exit point (OUT POINT). I would like to have a Calculated Column that returns 1 for every time it is activated between the in/out points.

 

It seems easy but I cannot manage to make it work. I would appreciate your help

1 REPLY 1
MattAllington
Community Champion
Community Champion

I don't see any pattern. Row 3 is 0,0,1. Row 5 is 0,0,0



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.