Creating a table based on another table Column Value

[erikah06]

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 the below formula, to no avail. 

Table = UNION(SUMMARIZE(Query1,Query1[Equipment],Query1[Equipment.1.Equipment Class.Class],Query1[STAT],Query1[TXT04],Query1[TXT30],Query1[Availability],Query1[Availability Rating]),

[AlB · Accepted solution]

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]

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