Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have week closing inventory in a table. For calculation purpose, I want to have another column named week opening inventory which will pick the previous periods closing inventory for same SKU. Can anyone suggest the best way to do it? I would love to know the way both in query and dax.
Regards,
Abrar
Solved! Go to Solution.
HI @Anonymous,
The simply way is reference previous steps table and add filter condition(same SKU and date greater than current date), then extract data list from filtered result table and use list function to get the min date.
After above steps, you will get the next period date you wanted.
Regards.
Xiaoxin Sheng
HI @Anonymous,
The simply way is reference previous steps table and add filter condition(same SKU and date greater than current date), then extract data list from filtered result table and use list function to get the min date.
After above steps, you will get the next period date you wanted.
Regards.
Xiaoxin Sheng
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |