Forum Discussion

turp111's avatar
turp111
Frequent Visitor
3 years ago
Solved

Adding Custom Column and pulling values from other rows

I need to add a new column with conditions but also to pull a value from another row if a certain condition is met.  Below is my table and columns, here are my conditions: If FEE_TYPE = 2 and SF_FI...
Need Help
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi turp111 

     

    Please use this new code:

    if [FEE_TYPE] = 2 and [SF_FIN_SERV_ID] <> "" then [SF_NAME1] else if [FEE_TYPE] = 2 and [SF_FIN_SERV_ID] = "" then "NATIONWIDE" else if [FEE_TYPE] = 1 then let vPlan = [PLAN] in List.Max(Table.SelectRows(#"previous step", each [PLAN] = vPlan and [SF_FIN_SERV_ID] = "TP")[SF_NAME1]) else ""

     

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

turp111's avatar
turp111
Frequent Visitor
3 years ago

Thank you, this is helpful.  That said, I should have been more clear about the data.  The example I gave here is just a subset.  The SF_NAME1 column has thousands of rows.  There should have been another column named 'PLAN' in my example.  So this subset of data would be for Plan 10.  I've added a new example of what I'm expecting.  So based on your first solution I'm getting the max value in SF_NAME1 for every row that meets that condition when I really need it only for Plan 10, and then a different value for Plan 20, etc.  Sorry for the initial confusion and hopefully this helps.

 

turp111's avatar
turp111
Frequent Visitor
3 years ago

This is just what I was looking for.  Thank you!