need to transfer excel formula into power query

[Mahmoud64]

Hi everyone,

This is my first time posting here. Need help with transferring this formula into power query

=B:B&"Shipping"&COUNTIF($B$2:B2,B:B)

Thanks in advance

[Fowmy]

@Mahmoud64 

Welcome to the community forum!
Can you share some sample data with the desired output to have a clear understanding of your question?
Mention whether you want a calculated column or measure.
You can either paste your data in the reply box or save it in OneDrive, Google Drive, or any other cloud-sharing platform and share the link here.

[Mahmoud64]

Hello, 

Many thanks. for ur help

 I wish these photos will help in solving the issue 

[v-jingzhang]

Hi @Mahmoud64 

Power Query uses M language. Its own functions are different from the Excel functions. You cannot use Excel formulas in Power Query Editor. Power Query M Formula Language Introduction

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Fowmy]

@Mahmoud64 
Please share sample or example data in Excel with the expected output column. You can save your file in Google or One Drive share the link here.