Multiply each filtered value

[sat125]

Hi, 

İ want to implement below formula for each month selected. how can i achieve this?

for example;

jan= 0,8 feb =2,4 march=-0,8  --> so first 3 months 

(((0,8+1) * (2,4 + 1) * (0,8 +1)) - 1) * 100

thanks

[v-yuta-msft · Accepted solution]

@sat125 ,

Create a measure using dax below:

Result = 
VAR First_Month = SELECTEDVALUE('Table'[Date].[Month])
VAR First_Month_Value = SUMX(FILTER(ALL('Table'), 'Table'[Date].[Month] = First_Month), 'Table'[Value])
VAR Second_Month = MONTH(EDATE(SELECTEDVALUE('Table'[Date]), 1))
VAR Second_Month_Value = SUMX(FILTER(ALL('Table'), MONTH('Table'[Date]) = Second_Month), 'Table'[Value])
VAR Third_Month = MONTH(EDATE(SELECTEDVALUE('Table'[Date]), 2))
VAR Third_Month_Value = SUMX(FILTER(ALL('Table'), MONTH('Table'[Date]) = Third_Month), 'Table'[Value])
RETURN
(((First_Month_Value + 1) * (Second_Month_Value + 1) * (Third_Month_Value + 1)) - 1) * 100

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

What is 0,8. Problem statement is not very clear

[sat125]

Hi,

İm trying to calculate the inflation ratio of the months selected so in this case ratio from january to march but im unable to do it with multiply quick measure. when i use it it multiplies the first selected month with itself for example 0,8 *0,8* 2,4 * -0,8

but i need it to multiply for the each month selected from month slicer.