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[TargetDate]), FILTER( ALL(DimDate),DimDate[Date] = DATE (YEAR ( TODAY ()), MONTH (TODAY () ) , 1 )))
 
Thanks
 
Liam
 
 
Need Help

2 Replies

  • 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