Forum Discussion

Alexandra_B's avatar
Alexandra_B
Helper III
4 years ago
Solved

MdxScript(model) (17, 14) error

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, b...
datesbetween
Need Help DAX
  • Alexandra_B's avatar
    Alexandra_B
    4 years ago

    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
Alexandra_B's avatar
Alexandra_B
Helper III
4 years ago

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