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

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.