Determine if a State is open in between two dates.

[vinceluc22]

State	Date	Cases
Alabama	1/1/2020	1
Alabama	1/2/2020	2
Alabama	1/3/2020	3
Alabama	1/4/2020	4
Alabama	1/5/2020	5
Alaska	1/1/2020	1
Alaska	1/2/2020	2
Alaska	1/3/2020	3
Alaska	1/4/2020	4

Above is a sample dataset. I'm trying to create a new column that evaluates Alabama and output OPEN if the Date is between 1/2/2020 and 1/4/2020. Otherwise, output CLOSED as the result. 

I tried adding a Quick Measure with a nested IF and DATESBETWEEN statement but it didn't work. It prints CLOSED for all of Alabama.

NewColumn = if('MyTable'[State] = "Alabama",if(DATESBETWEEN('MyTable'[Date],1/2/2020, 1/4/2020), "OPEN", "CLOSED"))

Any idea on how to get the result below?

State	Date	Cases	NewColumn
Alabama	1/1/2020	1	CLOSED
Alabama	1/2/2020	2	OPEN
Alabama	1/3/2020	3	OPEN
Alabama	1/4/2020	4	OPEN
Alabama	1/5/2020	5	CLOSED
Alaska	1/1/2020	1
Alaska	1/2/2020	2
Alaska	1/3/2020	3
Alaska	1/4/2020	4

[camargos88 · Accepted solution]

Hi @vinceluc22 ,

Try this code for a calculated column:

Column =

IF('Table'[State] = "ALABAMA";

IF('Table'[Date] >= DATE(2020;2;1) && 'Table'[Date] <= DATE(2020;4;1); "OPEN"; "CLOSED"))

Ricardo

[vinceluc22]

Thank You! Seems like the DATESBETWEEN statement wasn't needed.