Baseline Dax - extract data for each month

[Alexandra_B]

Hello.
I have a formula to calculate the baseline per month, I cannot figure out how to do it for each month, every month since July 21.

The formula is : Baseline = number + number * (monthly HDD + monthly CDD)

Any advice is welcomed.

Thank you.

[tamerj1]

@Alexandra_B 
Please try

=
VAR X = 10 --Insert correct value
VAR Y = 1.3 --Insert correctvalue
RETURN
    SUMX (
        VALUES ( CCD_18C[Month] ),
        --Use the column that you will be slicing by it
        VAR CurrentMonth = CCD_18C[Month]
        VAR CCDValue =
            CALCULATE ( SUM ( CCD_18C[CCD 18] ) )
        VAR HDDValue =
            CALCULATE ( SUM ( HDD_15C[HDD 15] ), HDD_15C[HMonth] = CurrentMonth )
        RETURN
            X + Y * ( CCDValue + HDDValue )
    )

[tamerj1]

Hi @Alexandra_B 

what is the relationship between the two tables? How does your visual look like? What are you slicing by?

[Alexandra_B]

I haven`t set a relationship. I just downloaded the data, two separate tables , they don`t interact with each other. I need to set a Dax to calculate that formula monthly. and then create a graph to show the values.