Forum Discussion

AlexGallet01's avatar
AlexGallet01
Helper 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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi AlexGallet01,

 

Would you please share some sample data and expected results for our analysis?

 

Best Regards,
Qiuyun Yu