Forum Discussion

Iculi's avatar
Iculi
Frequent Visitor
2 years ago
Solved

Baseline month data measure

Hi, Help me please. i need to create baseline volume info. baseline month is December 2023, yearly target will be 10% and i will need to check monthly basics to the results, so, how can i set Baseli...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Iculi 

     

    I tested your Dax and I came up with the problem:

    You misplaced the brackets,

    Here is the modified Dax:

    Baseline Volume =
        CALCULATE(
            SUM('DateTable'[Volume]),
                FILTER( DateTable,
                    YEAR(DateTable[Date])=2023
                    &&
                    MONTH(DateTable[Date])=12)
        )

    You can open the feature in the option, 

    so you can use this button to format the code for better inspection.

     

    Best Regards,

    Zhengdong Xu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Iculi 

 

I tested your Dax and I came up with the problem:

You misplaced the brackets,

Here is the modified Dax:

Baseline Volume =
        CALCULATE(
            SUM('DateTable'[Volume]),
                FILTER( DateTable,
                    YEAR(DateTable[Date])=2023
                    &&
                    MONTH(DateTable[Date])=12)
        )

You can open the feature in the option, 

so you can use this button to format the code for better inspection.

 

Best Regards,

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Iculi's avatar
    Iculi
    Frequent Visitor
    2 years ago

    Hi Zhengdong Xu,

    Thank you for your answer, i also find the solution but my formula a little bit different, in the FILTER part i have used different way: FILTER(DateTable,DateTable[Year]=2023 && (DateTable[Month_nr]=12)))

    and it is also work. But i will use your version.. 🙂

    Thank you for your help!

    Icu