Forum Discussion

Sudheeshp's avatar
Sudheeshp
Frequent Visitor
3 years ago
Solved

New custom column

My table has column name 'Unique Customer' and 'Promo ID'. if any of the row value 'Unique Customer' has a 'Promo ID' greater than null, then likes to create a new column 'VFP Customer' with "Y" as v...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Sudheeshp ,

     

    This is my easy-to-understand method.

    1.Add a custom column to return 1 or 0.

    2.Group by as follows.

    3.Add a custom to return the result.

    4.Expand the Tables in the column.

       

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

     

Sudheeshp's avatar
Sudheeshp
Frequent Visitor
3 years ago

I have to add as a custom column and apply this, is it??The following is my source!!

Folder.Files("C:\INVENTORY\YEAR\ALL FILES\RETAIL SALES\DAILY SALES\VFP ANALYSIS")

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
3 years ago

Open your file in PQ and in the code generated, copy the code ListNonBlanks till the end and paste into your code after Source. 

  • Sudheeshp's avatar
    Sudheeshp
    Frequent Visitor
    3 years ago

    Well, I am getting errors.  I think the unique customer is a additional colu mn, and there are columns added in the power query, after importing

  • Sudheeshp's avatar
    Sudheeshp
    Frequent Visitor
    3 years ago

    I am so thankful for all the reply.  Much much appreciated.  however i do not know how to do this additional column by comparing two cell values:)🤔