Target date in current month

[Anonymous]

Hi,

I'm trying to obtain a count for target dates that are in current month?

I have below but the target date displays blank in my matrix.

Target date in month = CALCULATE(SUM(vwtest[TargetDate]), FILTER( ALL(DimDate),DimDate[Date] = DATE (YEAR ( TODAY ()), MONTH (TODAY () ) , 1 )))

Thanks

Liam

[Anonymous]

Hi @Anonymous ,

I'm not sure if have understood you query correctly but please use below DAX if you are looking to Count the rows in target date for today.

NewColumn =
CALCULATE ( COUNT ( vwtest[TargetDate] ), DimDate[Date] = TODAY () )

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.

Regards,

Gaurav Raj Singh

LinkedIN : https://www.linkedin.com/in/gauravrajsingh/

[Anonymous]

Hi @Anonymous ,

Thanks for your reply.

If thats target date today, what would target date within current month be, E.G. in February?

Thanks

Liam