Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Here is my dataset. As I have quantites for a particular material for oct,nov & dec 2022. Now I want to carry forward these quantites in next year to jan,feb & march 2023. Basically my requirement is I want to carry forward the quantites to next year only when the quantites of next year are blank or null until a quantity for next year is present for a particualr date. If they are not null I wont carry forward. Can someone help me in this ?
The required O/P is in the Required O/P Column .
Thanks
sd22
Solved! Go to Solution.
@sd22 , Try fill down in the power query
Power Query - Fill Up Fill Down: https://youtu.be/mC2ps0pFqBI
Thanks a lot Amit. It worked
@sd22 , Try fill down in the power query
Power Query - Fill Up Fill Down: https://youtu.be/mC2ps0pFqBI
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |