Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi guys,
i need to create a measure that works like this:
How can I create it?
Thank you all 🙂
Solved! Go to Solution.
@bhanu_gautam , Thank you for your positive response to the post.
Here is my solution, I hope this helps.
1.Create a measure to calculate Y/100.
FirstMonthYDiv100 = CALCULATE(
MIN('Table'[Y]),
FILTER(
ALL('Table'),
'Table'[Month] = MINX(ALL('Table'), 'Table'[Month]
)
)
)/100
2.Create a cumulative measure for column X.
CumulativeSumX = CALCULATE(
SUM('Table'[X]),
FILTER(
ALLSELECTED('Table'),
'Table'[Month] <= MAX('Table'[Month])
)
)
3.Create a measure Z.
Z = [FirstMonthYDiv100] + [CumulativeSumX]
4.Here is my final result.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@bhanu_gautam , Thank you for your positive response to the post.
Here is my solution, I hope this helps.
1.Create a measure to calculate Y/100.
FirstMonthYDiv100 = CALCULATE(
MIN('Table'[Y]),
FILTER(
ALL('Table'),
'Table'[Month] = MINX(ALL('Table'), 'Table'[Month]
)
)
)/100
2.Create a cumulative measure for column X.
CumulativeSumX = CALCULATE(
SUM('Table'[X]),
FILTER(
ALLSELECTED('Table'),
'Table'[Month] <= MAX('Table'[Month])
)
)
3.Create a measure Z.
Z = [FirstMonthYDiv100] + [CumulativeSumX]
4.Here is my final result.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@giuliapiazza94 , Can you explain what exactly you are trying to do
Proud to be a Super User! |
|
I need to create Z but I don't know how
X and Y are two measures.
X = total of new customers of month
Y = total customers
I need to create Z:
Z of first month selected (in this example is january) = Y / 100
Z of other months = Z(previous month) + X
User | Count |
---|---|
30 | |
18 | |
15 | |
14 | |
10 |