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.
Hello fellows! I have little experiencie with DAX. I've been trying to create an expression to solve my problem.
I have a 3 tables.
Initial Stock (not linked with DateTable, because it is a snapshot of my current stock position)
Transit (linked with DateTable)
Demand (linked as well)
Final_Stock ( Initial Stock + Transit - Demand)
Here is where I'm stucked, what I've been trying to accomplish.
I have the initial stock and did the measure to give me the Final Stock for this month (Initial Stock + Transit - Demand) .
However, for the calculation for the next months, the initial stock to be considered should be the final stock from previous month.
The biggest problem I'm facing: If the final stock from previous month is negative, the next month should considere 0 as the initial stock and start over the process again.
What I did and is not working well.
Any help will be appretiated!!!
Thank you all.
Hi:
Something like:
=
no... it is repating the value across the months
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 |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
73 | |
50 | |
45 | |
20 | |
17 |