MdxScript(model) (17, 14) error

Question

Hello.While I try to call a function, I get the following error:&nbsp;&nbsp;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.&nbsp;How can I fix it, please?&nbsp;Thank you.&nbsp;#needhelp

alexandra_b · Accepted Answer

Hi all.I have managed to resolve this with the following formula:co2 21 22 = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CALCULATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ( &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'table_hidden_name'[tonnes co2 main], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DATESBETWEEN('table_hidden_name'[Date and time].[Date], DATE(2021, 07, 01),DATE(2022, 06, 30)))&nbsp;Thank you

Forum Discussion

MdxScript(model) (17, 14) error

1 Reply

Related content

MDXScript(Model) calculation Error

MdxScript(Model)(17,3) calculation error

Error MdxScript(Model) (196,47)

MdxScript(Model) Calculation error in measure

MdxScript(Model) / Calulcation error in (...)