Forum Discussion
sd22
3 years agoFrequent Visitor
DAX
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
sd22 , Try fill down in the power query
Power Query - Fill Up Fill Down: https://youtu.be/mC2ps0pFqBI
2 Replies
- amitchandakSuper User
sd22 , Try fill down in the power query
Power Query - Fill Up Fill Down: https://youtu.be/mC2ps0pFqBI
- sd22Frequent Visitor
Thanks a lot Amit. It worked