DAX formula to be used in trending graph

[CVL]

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

[adudani]

Hello,

Kindly provide the sample input/output in a good format (excel, csv, table etc.) masking sensitive information.

reference : https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Thanks,