Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
53 | |
35 | |
20 | |
16 | |
15 |
User | Count |
---|---|
94 | |
72 | |
30 | |
22 | |
14 |