Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hey guys!
I was wondering if there was any way I could create a measure using DAX that is capable of adding the value of itself in the past.
The first instance of the variable “Measure”, represented by the letter “a” in the yellow column, would be equal to 0, that is, on the first date chosen by the user. In the following instances, the value of the variable “Measure” should be equal to the value of the “Contribution” variable plus the “Measure” variable in the previous instance multiplied by the “Divisaocota” variable of the instance divided by the “Divisaocota” variable of the previous instance.
Here is an example of what I mean:
Measure0 = 0
Measure1 = Contribution1 + Measure0 (Divisaocota1/Divisaocota0)
Measure2 = Contribution2 + Measure1 (Divisaocota2/Divisacao1)
Data are in: https://drive.google.com/drive/folders/1wfkZjv2cpnAZpa0F30PTcmr6n7DKZGkS?usp=sharing
I read some documents about recursion here, but none fit my measure. How would I go about doing this?
Thanks so much guys!
@STEPH0018 Short answer is that it is more trouble than it is worth. Previous Value (“Recursion”) in DAX - Microsoft Power BI Community
Someone would know that?
So, do you think it's basically impossible to do that in power bi DAX?
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |