Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |