column fill down with a condition

[surajde]

Hi All, 

Please help me with below scenario where calculated column needs to be filled down with a condition. 

if ticket number is same then work queue should be filled down and until then "No WQ". 

when ticket number changes then No WQ util Work_Queue has a value. then logic continues. 

final result should look like column N = WQ-Full

[v-zhangti]

Hi, @surajde 

You can try the following methods. First add index column in the Power Query.

Column = 
Var _N1=CALCULATE(MAX('Table'[Index]),FILTER('Table',[Index]<=EARLIER('Table'[Index])&&[WORK_QUEUE]<>BLANK()))
Return
IF(_N1=BLANK(),"NO WQ",CALCULATE(MAX('Table'[WORK_QUEUE]),FILTER('Table',[Index]=_N1)))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[surajde]

Thanks for help but this one is not helping when there are multiple tickets.. Please help write formula with multiple ticket numbers in the first column. 

Initially there may not be a queue for new ticket but queue will be assigned later as you can see in first tticket. 

[amitchandak]

@surajde , First use fill down in Power Query and then replace null with No-WQ

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

Power BI- Power Query Conditional Replace Value- https://youtu.be/Qj2bthdusiM