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.
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