Forum Discussion

sat125's avatar
sat125
Frequent Visitor
6 years ago
Solved

Multiply each filtered value

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

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    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.

3 Replies

    • sat125's avatar
      sat125
      Frequent Visitor
      6 years ago

      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.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    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.