Forum Discussion
Calculating Variables with Different Months
Hi! I need to create a measure where I divide the sum of two values, with one month difference between them and both being qualified by another variable. Something like this: SUM(Consulta1[B] HA...
Are you trying to do that in a column or a measure?
Hi
You could modify formula in measure as below
MEASURE =
DIVIDE (
CALCULATE ( SUM ( [B] ), FILTER ( ALL ( consultal ), MAX ( [c] ) = "C31-60" ) ),
CALCULATE ( SUM ( [A] ), FILTER ( ALL ( consultal ), MAX ( [C] ) = "A 000" ) )
)The formalu above lack the condition of something about month since i don't understand about “one month difference between them”, what does this mean?
Best Regards
Maggie
