Unable to filter dates correctly

EdwardChurches — Thu, 25 Aug 2022 18:28:44 GMT

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?

Re: Unable to filter dates correctly

EdwardChurches — Thu, 25 Aug 2022 18:53:44 GMT

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.