How to convert a sql statement to dax

[Anonymous]

I am very new to Power BI and I am having a hard time converting a sql statement to dax.  I work in law enforcement and need to count the number of cases we have had during a certain date range in a 10 year period.  For example January 1 - June 15 for the years 2010 - 2019.  Following is my current sql statement:

WHERE (((Year([DATEOFDEAT]))>=2010) AND ((Month([DATEOFDEAT])) Between 1 And 5) AND ((Day([DATEOFDEAT]))<Date())) OR (((Year([DATEOFDEAT]))>=2010) AND ((Month([DATEOFDEAT]))=6) AND ((Day([DATEOFDEAT])) Between 1 And 15))

As a workaround, I created one dax statement for each year.  So, ten total dax statements for one report tile which feels like overkill.  Here is an example of the dax for year 2010:

1  Count of Murders 2010 =

2  CALCULATE(

3           COUNT(tblMurders[CN]),

4           DATESBETWEEN(

5                    tblMurders[DATEOFDEAT].[Date],

6                    DATE(2010,1,1),

7                    DATE(2010,6,15)

8           )

9  )

Any help would be very much appreciated.

Thanks!!!