DAX

[sd22]

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]

Thanks a lot Amit. It worked

[amitchandak · Accepted solution]

@sd22 , Try fill down  in the power query

Power Query - Fill Up Fill Down: https://youtu.be/mC2ps0pFqBI