Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Community Experts,
I need to increment a measure with each refresh (manual or scheduled) of my power bi.
I need to take input from user and need to set the measure initial value as haf of the entered value and with each refresh want to add this half value to the measure previous value.
I have used 'what-if' parameter to take user's input but unable to increment the meausre recursively.
Example: Parameter 1 Value = 10 (user entered value)
var y = (parameter Value 1 ) /2
x (measure to set initially and increment) = 0
Now I want x to behave like this with each refresh
x= x + y
First time x=5 (as user enterd 10 and y is half of parameter value; x= 0 +5)
refresh: x = 10 (x= 5, y = 5)
another refresh: x =15 (10+5)
Is this poassible to achieve ?
Thanks.
Solved! Go to Solution.
Hi @Raaz ,
I'm afraid your requirement is difficult to realize,as we cant calculate based on refresh,and after refresh,all the data will be rewritten.
Hi @Raaz ,
I'm afraid your requirement is difficult to realize,as we cant calculate based on refresh,and after refresh,all the data will be rewritten.
User | Count |
---|---|
91 | |
84 | |
64 | |
62 | |
58 |
User | Count |
---|---|
148 | |
112 | |
95 | |
81 | |
71 |