Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
@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.
What is 0,8. Problem statement is not very clear
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |