Forum Discussion

surajde's avatar
surajde
Icon for Helper I rankHelper I
3 years ago

column fill down with a condition

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

 

 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    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's avatar
      surajde
      Icon for Helper I rankHelper I
      3 years ago

      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.