Forum Discussion

AlexGallet01's avatar
AlexGallet01
Icon for Helper IV rankHelper IV
9 years ago
Solved

Foreach

Hi,   I need help for do a foreach. I want to calculate week number foreach send number but i have any times the send number so i want calculate the week number just one time foreach send number. ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi AlexGallet01,

     

    You can use Find() function to create a calcualted column like this:

     

    Column = IF(FIND(160170,'Table1'[Column1],5,0)>0,-2,BLANK())

     

     

    Best Regards,
    Qiuyun Yu

AlexGallet01's avatar
AlexGallet01
Icon for Helper IV rankHelper IV
9 years ago

I want to do a foreach to calculate the number of weeks of delays in sending by number of shipments knowing that this number exists several times in my table.