Forum Discussion
DAX calculation with previous calculated value
meskens Yes, that helps a lot. Unfortunately, there is no clean way of doing this sort of thing in DAX as DAX does not really support previous value/recursion. Previous Value aka "Recursion" - Microsoft Power BI Community
Community Championmeskens Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Would this be of any help?
Stock forecast 2022 would be Stock Quantity 2021 + Prod forecast Quantity 2021 - Sales Forecast Quantity 2022
Stock forecast 2023 would be Stock forecast 2022 + Prod forecast Quantity 2022 - Sales Forecast Quantity 2023
Table name Date Prod forecast Sales forecast Stock Column name Year Quantity Quantity Quantity Stock Forecast (to be calculated) 2021 4.844.683 7.697.000 24.629.251 2022 4.264.317 7.000.000 22.473.934 2023 2.208.508 7.000.000 19.738.251 2024 - 7.000.000 14.946.759 2025 2.147.410 7.000.000 7.946.759
