Forum Discussion

erikah06's avatar
erikah06
Helper I
7 years ago
Solved

Creating a table based on another table Column Value

Hi,    I would like to create a new table based on Table Above, 'Query1' filtered [STAT] Column. I only want to pull rows into the new table with the field "E0004" in the [STAT] column. I tried...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi  erikah06 

     

    If you want to keep the rows with "E0004" in the [STAT] column, can you not simply filter?

    Create a new calculated table:

     

    NewTable = FILTER(Table1, Table1[STAT] = "E0004")
AlB's avatar
AlB
Community Champion
7 years ago

Hi  erikah06 

 

If you want to keep the rows with "E0004" in the [STAT] column, can you not simply filter?

Create a new calculated table:

 

NewTable = FILTER(Table1, Table1[STAT] = "E0004")
  • erikah06's avatar
    erikah06
    Helper I
    7 years ago

    Hi AlB obviously looking at this stuff too long, I'm becoming delusional. Thank you for always sharing your expansive knowledge!