Solved: Re: Dax error!

Anonymous · ‎05-18-2022

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!

Anonymous · ‎05-22-2022

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.

Anonymous · ‎05-22-2022

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.

Dax error!