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.
Dear,
How to achieve the result like that
category | Month number | value | result | result formula |
Actual & Forecast Cost | 7 | |||
Actual & Forecast Cost | 2 | 144.7975 | =C8*C16/C17 | |
Actual & Forecast Cost | 3 | 185.2036 | =E3*C17/C18 | |
Actual & Forecast Cost | 4 | 166.8426 | =E4*C18/C19 | |
Actual & Forecast Cost | 5 | =E5*C19/C20 | ||
Actual & Forecast Cost | 6 | ….. | ||
Actual & Forecast Cost | 1 | 146 | ||
Actual & Forecast Cost | 8 | |||
Actual & Forecast Cost | 9 | |||
Actual & Forecast Cost | 10 | |||
Actual & Forecast Cost | 11 | |||
Actual & Forecast Cost | 12 | |||
Commercial sales 1+11 | 1 | 71426 | ||
Commercial sales 1+11 | 2 | 73758 | ||
Commercial sales 1+11 | 3 | 85611 | ||
Commercial sales 1+11 | 4 | 86322 | ||
Commercial sales 1+11 | 5 | 67489 | ||
Commercial sales 1+11 | 6 | 78964 | ||
Commercial sales 1+11 | 7 | 87654 | ||
Commercial sales 1+11 | 8 | 98765 | ||
Commercial sales 1+11 | 9 | |||
Commercial sales 1+11 | 10 | |||
Commercial sales 1+11 | 11 | |||
Commercial sales 1+11 | 12 |
@woshi_eads Have you resolved this problem? I also want to achieve something like this.
HI @woshi_eads,
According to the snapshot, it seems like you want to achieve recursive calculations. AFAIK, current power bi Dax formula does not support these calculations.
You can also take a look at the Greg’s the blog about research in Dax recursive if helps:
Previous Value (“Recursion”) in DAX – Greg Deckler
Regards,
Xiaoxin Sheng
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |