Forum Discussion

zenton's avatar
zenton
Helper II
3 years ago
Solved

Loop though Iteration based on another column

Hi,   Problem 1 I need help with calculating the Bay in Use column. Bay in u\Use starts with Bay1 When Column FULL = "Full" Bay in Use = Bay 2, then Bay 3, Bay 4 When Bay 4 is full the cycle st...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi zenton 

    You can refer to the following column

    Bay in use = var _filter=COUNTROWS(FILTER('Table',[Index]<=EARLIER('Table'[Index])&&[FUll]="Full"))
return "Bay"&" "&MOD(_filter,4)+1

    Best Regards!

    Yolo Zhu

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi zenton 

You can create two calculated column

 

 

Bay in use = var _filter=COUNTROWS(FILTER('Table',[Index]<=EARLIER('Table'[Index])&&[FUll]="Full"))
return IF(_filter>3,"Bay"&_filter+1-4,"Bay"&_filter+1)

Date Empty = IF([FUll]="Full",[Date]+13)

 

 

 

Best Regards!

Yolo Zhu

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

zenton's avatar
zenton
Helper II
3 years ago

Hi Anonymous , Thanks fio your help. The calcultion works for the 1st itteration only. Idex row 43 should be Bay1

Thanks Rodney

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi zenton 

    You can refer to the following column

    Bay in use = var _filter=COUNTROWS(FILTER('Table',[Index]<=EARLIER('Table'[Index])&&[FUll]="Full"))
return "Bay"&" "&MOD(_filter,4)+1

    Best Regards!

    Yolo Zhu

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