Unable to filter dates correctly

[EdwardChurches]

Hi,

Im new to DAX and Im having trouble using the calculate formula to filter dates. This is what i did:

1. Found the beginning of the latest month using this formula: 

bMonth:=EOMONTH ( MAX ( fTransactions[Emision] ), -1 ) + 1
   

2. Use calculate function to filter everything after  that date: 

CALCULATE ( [Units], FILTER ( dDate, dDate[Date] >= [bMonth] ) )

I know the error is in step 1 because if  I replace [bMonth] for the DATE formula, the filter works fine.

I dont understand what im doing wrong, can  somenone please help?

[EdwardChurches · Accepted solution]

Well... aparently I just solved this by joining step one and two togehter: 

CALCULATE ( [Units], FILTER ( dDate, dDate[Date] >= EOMONTH ( MAX ( fTransactions[Emision] ), -1 ) + 1 ) )

I dont know why that makes a difference but there it is.