Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
This is my table, I want the closing stock value of a client for a particular month to be assigned to the opening stock of the next month.
example : 12/31/2020 value is 18079, I want this to appear on 1/4/2021, but what i have is 34984.
Is there a way to do this, pls help its urgent
Solved! Go to Solution.
@Anonymous , With help from the date table, try openingbalancemonth
openingbalancemonth(Sum('Table'[Value]), Date[Date])
refer my video : https://youtu.be/6lzYOXI5wfo?t=117
This is not working for me unfortunately.
User | Count |
---|---|
122 | |
109 | |
97 | |
60 | |
57 |
User | Count |
---|---|
137 | |
114 | |
102 | |
70 | |
56 |