Recursive addition of a measure

[Raaz]

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.

[mwegener · Accepted solution]

Hi @Raaz ,

take a look at this.

https://www.thebiccountant.com/2020/04/13/create-a-load-history-or-stage-in-cds-instead-of-increment...

You can implement user input with a power app if necessary.

[v-kelly-msft · Accepted 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.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mwegener · Accepted solution]

Hi @Raaz ,

take a look at this.

https://www.thebiccountant.com/2020/04/13/create-a-load-history-or-stage-in-cds-instead-of-increment...

You can implement user input with a power app if necessary.