topic Re: Under 18 at any point during a time Frame? in DAX Commands and Tips

Under 18 at any point during a time Frame?

pdoucette — Wed, 23 Sep 2020 15:44:17 GMT

I'm trying to figure out a way to see if a person we served was, at any point, under the age of 18 during a given time frame....7/1/19 - 6/30/20. Age would be calculated off of a Birthdate field.

Re: Under 18 at any point during a time Frame?

jthomson — Wed, 23 Sep 2020 16:27:46 GMT

Well you're only interested in the earliest part of the time frame - I don't know where that's coming from and it doesn't really matter, try something like:

18check = var earliesttimeframe = min(however you are defining your time frame)

var whenpersonis18 = dateadd([birthdate],18,year)

return if (earliesttime<whenpersonis18,"was under 18","wasn't under 18")

Re: Under 18 at any point during a time Frame?

Regex — Wed, 23 Sep 2020 17:29:09 GMT

Please see full solution below.

Table1 contains two columns, with "Persons Name" and "Birthdate"

WasUnderage:=IF(COUNTROWS(Table1) <> 1, BLANK(), VAR DateOfBirth = VALUES(Table1[Birthdate]) VAR Date18 = DATE(YEAR(DateOfBirth)+18, MONTH(DateOfBirth), DAY(DateOfBirth)) VAR result = AND(DateOfBirth <= DATE(2020,30,6), Date18 > DATE(2019,7,1)) RETURN result )

Re: Under 18 at any point during a time Frame?

pdoucette — Thu, 24 Sep 2020 12:54:20 GMT

Thank You, I think this is close but I am returning all False values but feel I met the Result...I will keep playing with it

Re: Under 18 at any point during a time Frame?

Regex — Thu, 24 Sep 2020 15:51:56 GMT

Hi,

There is a mistake in the order of one of the dates:

Try changing DATE(2020, 30, 6) to DATE(2020, 6, 30)