Forum Discussion

PBI-BOLA's avatar
PBI-BOLA
Frequent Visitor
5 years ago
Solved

Filtering table before expanding column

Hi,   I'm trying to filter a table in a column before expanding it as the table is extremely large if I don't. I have found another solution to a similar question but it doesn't appear to work for ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I would proceed like this:

    Table.addcolumn (# "Choose columns", "Company", each Table.SelectRows (_ [PBI_Change_Log_Entries], (r) => r [Table_Caption] = "Vendor Bank Account"))

    instead of

    # "Renamed columns" = Table.RenameColumns (# "Choose columns", {{"Name", "Company"}}),

     

    then you delete the [name] column and finally expand the [Company] column.

     

    I couldn't test the code, so pay attention to syntax and name matching.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

you should change this 

Table.addcolumn (# "Choose columns", "Company", each Table.SelectRows (_ [PBI_Change_Log_Entries], (r) => r [Table_Caption] = "Vendor Bank Account"))

 

to  somethink like this

 

 

Table.addcolumn (# "Choose columns", "Company", each Table.SelectRows (_ [PBI_Change_Log_Entries], (r) => r [Table_Caption] > #date(2020,1,1) and  r [Table_Caption] < #date(2020,12,ù31) ))

 

 

but if your choices fall into one of the many cases provided by MS and that you find here you could simplify the filter using one of these functions

 

 

PBI-BOLA's avatar
PBI-BOLA
Frequent Visitor
5 years ago

Thanks