topic Re: Calculated Column identify cases between two dates in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-identify-cases-between-two-dates/m-p/1519352#M29598 <P>I don't see any pattern. Row 3 is 0,0,1. Row 5 is 0,0,0</P> Thu, 26 Nov 2020 19:22:29 GMT MattAllington 2020-11-26T19:22:29Z Calculated Column identify cases between two dates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-identify-cases-between-two-dates/m-p/1519127#M29585 <P>Hello,</P><P>&nbsp;</P><P>I have a database with the following structure:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>ID</TD><TD>In Point</TD><TD>Out Point</TD><TD><FONT color="#0000FF">Desired Column</FONT></TD></TR><TR><TD>A</TD><TD>0</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>A</TD><TD>1</TD><TD>0</TD><TD><FONT color="#0000FF">1</FONT></TD></TR><TR><TD>A</TD><TD>0</TD><TD>0</TD><TD><FONT color="#0000FF">1</FONT></TD></TR><TR><TD>A</TD><TD>0</TD><TD>1</TD><TD><FONT color="#0000FF">1</FONT></TD></TR><TR><TD>A</TD><TD>0</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>B</TD><TD>1</TD><TD>0</TD><TD><FONT color="#0000FF">1</FONT></TD></TR><TR><TD>B</TD><TD>0</TD><TD>1</TD><TD><FONT color="#0000FF">1</FONT></TD></TR><TR><TD>B</TD><TD>0</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>B</TD><TD>1</TD><TD>0</TD><TD><FONT color="#0000FF">1</FONT></TD></TR><TR><TD>B</TD><TD>0</TD><TD>1</TD><TD><FONT color="#0000FF">1</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>It seems easy but I cannot manage to make it work. I would appreciate your help</P> Thu, 26 Nov 2020 15:01:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-identify-cases-between-two-dates/m-p/1519127#M29585 nicolasvargas 2020-11-26T15:01:50Z Re: Calculated Column identify cases between two dates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-identify-cases-between-two-dates/m-p/1519352#M29598 <P>I don't see any pattern. Row 3 is 0,0,1. Row 5 is 0,0,0</P> Thu, 26 Nov 2020 19:22:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-identify-cases-between-two-dates/m-p/1519352#M29598 MattAllington 2020-11-26T19:22:29Z