Forum Discussion

Mahmoud64's avatar
Mahmoud64
New Member
4 years ago

need to transfer excel formula into power query

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
Need Help
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

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's avatar
Mahmoud64
New Member
4 years ago

Hello, 

Many thanks. for ur help

 

 

 

 I wish these photos will help in solving the issue 

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    4 years ago

    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. 

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.