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

4 Replies

  • 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.