Count Unique values between a date range

[Rince91]

Hey,

Had to share this as i've been trying to figure it out for a week now. Finaly got it.

So the intention of the below is to add a column in that defines if the row is between the start data and end date, adding a "Yes/No" where true or false. It then filters the table on "Yes" and counts the unique values in a specific coulmn. 

Where i have used this is to count the tickets raised last month and then compare to the tickets raised the previous month to show a specific increase or decrease in ticket numbers.

This took me ages to figure out, hopefully helps someone else!

Unique Count = 

VAR StartDate = EOMONTH(TODAY(),-2)+1
VAR EndDate = EOMONTH(TODAY(),-1)

RETURN
CALCULATE(
DISTINCTCOUNT(Table1[Refference]),
Filter(
ADDCOLUMNS(
Table1,
"Last Month", IF(Table1[CLOSE_TIME_Month_Year] >= StartDate
&& Table1[Table1] <= EndDate, "Yes", "No")),[Last Month] = "Yes"))