Forum Discussion

psmalley-ati's avatar
psmalley-ati
New Member
3 years ago
Solved

Select single value in nested table for a new column

I have a nested table that I expanded using the table.expandtablecolumn. One of the columns that I expanded also has a nested table of its own that can have multiple rows.    This nested table with...
Need Help
Tutorial Requests
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi psmalley-ati 

     

    Assume your data is like below, the nested table column is called "Values".

    You can add a custom column with below code

    Table.SelectRows([Values], each [is_last_user_for_fct] = true)[last_seen]{0}

    Result:

     

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

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi psmalley-ati 

 

Assume your data is like below, the nested table column is called "Values".

You can add a custom column with below code

Table.SelectRows([Values], each [is_last_user_for_fct] = true)[last_seen]{0}

Result:

 

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