Dax error!

Anonymous — Wed, 18 May 2022 22:49:32 GMT

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!

Re: Dax error!

Anonymous — Mon, 23 May 2022 05:54:09 GMT

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.