MdxScript(model) (17, 14) error

[Alexandra_B]

Hello.
While I try to call a function, I get the following error:

I have used the formula for two more visuals (the one in the snip) with different data, so I just changed the tables, but got this error on visual. I need this to create a Clustered column chart and then use the data into a KPI.

How can I fix it, please?

Thank you.

#needhelp

[Alexandra_B · Accepted solution]

Hi all.
I have managed to resolve this with the following formula:

co2 21 22 =

             CALCULATE

                               (

                                'table_hidden_name'[tonnes co2 main],

                                 DATESBETWEEN('table_hidden_name'[Date and time].[Date], DATE(2021, 07, 01),DATE(2022, 06, 30)

))

Thank you