topic Re: Baseline Dax - extract data for each month in DAX Commands and Tips

Baseline Dax - extract data for each month

Alexandra_B — Fri, 01 Jul 2022 09:50:03 GMT

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.

Re: Baseline Dax - extract data for each month

tamerj1 — Fri, 01 Jul 2022 10:36:02 GMT

Hi Alexandra_B

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

Re: Baseline Dax - extract data for each month

Alexandra_B — Fri, 01 Jul 2022 12:41:44 GMT

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.

Re: Baseline Dax - extract data for each month

tamerj1 — Fri, 01 Jul 2022 13:15:02 GMT

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 ) )