Forum Discussion

bcampbell's avatar
bcampbell
Icon for Helper I rankHelper I
7 years ago
Solved

New Table with specific values from another table column

I have a Table that contains 2 columns that i want to create a new table from    1 of those columns is date / time of  and the other column contains a 4 letter value   I would like to make a new ...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi bcampbell

     

    You can simply create a new table with this code:

     

    NewTable = FILTER(YourCurrentTable; YourCurrenTable[Value]="ABCD")

     

    where "ABCD" is the specific 4-letter value you want to keep.  

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi bcampbell

 

You can simply create a new table with this code:

 

NewTable = FILTER(YourCurrentTable; YourCurrenTable[Value]="ABCD")

 

where "ABCD" is the specific 4-letter value you want to keep.