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.
Hello,
i'm trying to create a measure that gives me the variation between values of a month and the month before.
how can i make that measure for the 3 columns that i show on the image,
thank you,
JR
Solved! Go to Solution.
Yulanda,
i've got it. using the function PREVIOUSMONTH it gives me the values that i've want.
thank you for the help,
JR
Hi @jppuam,
Suppose the fields [PMR] in above matrix is a measure. To get the difference between current month and previous month, please new a measure like this:
last month value = [PMR] - CALCULATE ( [PMR], FILTER ( ALL ( 'TableName' ), 'TableName'[Mes] = SELECTEDVALUE ( 'TableName'[Mes] ) - 1 ) )
Regards,
Yuliana Gu
Yuliana,
i've post on other message the formulas that i'm using for that calculation....
i dont really understand that formula that i've shown below. can you see my post and analise it ?
thank you,
JR
Yulanda,
that not quiet what i need, because you're doiing the diferente.
i need in the right column the values of the previous months, to make a variation from the current month versus the month before.
thank you,
JR
Yulanda,
i've got it. using the function PREVIOUSMONTH it gives me the values that i've want.
thank you for the help,
JR
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 |
---|---|
108 | |
98 | |
79 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |