topic Re: Target date in current month in DAX Commands and Tips

Target date in current month

Anonymous — Tue, 11 Feb 2020 15:56:05 GMT

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 — Wed, 12 Feb 2020 05:02:53 GMT

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

Anonymous — Wed, 12 Feb 2020 10:17:51 GMT

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