Creating a table based on another table Column Value

Question

Hi,&nbsp;&nbsp;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.&nbsp;&nbsp;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 Answer

Hi&nbsp; erikah06&nbsp;
&nbsp;
If you want to keep the rows with "E0004" in the [STAT] column, can you not simply filter?
Create a&nbsp;new calculated table:
&nbsp;
NewTable = FILTER(Table1, Table1[STAT] = "E0004")

Forum Discussion

Creating a table based on another table Column Value

2 Replies

Related content

Sort by another column

Create columns group

Creating a Measure: Filtering Text Column, with text from another column

Column created in a table appears in another table

Find Most Recent Date Relative to another Date Column in Power Query