Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Target date in current month

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[Tar...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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