Forum Discussion

CVL's avatar
CVL
Regular Visitor
2 years ago

DAX formula

Dear all,

I'm looking for a DAX formula.

I have the following data:

 

From this I want to create a trending graph, so showing 2023ACT and 2024BUD in the same graph, monthly figures.

I would like to have the data of the green items to be displayed in my graph.

So for the 2023ACT the category C2 should be taken. But not when the scenario is 2024BUD. As in 2024BUD I want to have the selection of the scenario's MEN_C2, MEN_C2_ALLOC2 and MEN_C2_CANCEL2.

In the scenario 2024BUD he can't take at all the C2 category, as this is not with monthly figures but only December.

Somebody who can help me with the correct DAX please?

Thanks a lot

Kind regards

Cindy

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi CVL ,

     

    Not quite sure what you mean, can you provide sample data? Explain your intention, e.g. what does MEN_C2, MEN_C2_ALLOC2 and MEN_C2_CANCEL2 stand for?

     

    Best regards,
    Community Support Team_ Scott Chang