Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax error!

Hello,I am trying to write a DAX statement which should show the sum of all the tickets with status as opened for the current month. 

 

Can someone please tell me the syntax for it?

 

Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please try:

     Calculate(sum(value), filter ('table', [status]="opened" && Month([Date])= Month(Today()) ))

     

     

    Best Regards,
    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Please try:

     Calculate(sum(value), filter ('table', [status]="opened" && Month([Date])= Month(Today()) ))

     

     

    Best Regards,
    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.