Returning a table, expected a single value - I'm confused!

[Voose]

Hi All,

I'm trying to get this calculation to work:

Start month of util = if(DATESBETWEEN('Timecard Split'[pse__End_Date__c],FIRSTNONBLANK('Utilization Calculation'[first of this month].[Date],1),[Todays Date]),"Y","N")

I basically want the formula to work out the 1st day of a month and then today, and if the date on the row is between those 2 values then "y".

To explain the above, timecardsplit - end date is just a column of dates in my row

Utilizaion calculation[first of this month] is a column with a single row that has the 1st date of the current month

[Todays date] is a measure that reads =Today()

Any help would be much appreciated chaps

Thanks

Voose