Filter a table

[srpeters]

I am trying to make a new table based off of an existing one. I want to select a few columns to add to this table but filter all of them based off of one of the columns entries. In the column I am trying to use as a filter for this new table, it has Y or N. I only want to bring the rows from the first table that has Y in this column. 

Thank you

[v-xinruzhu-msft · Accepted solution]

Hi @srpeters 

You can use selectcolumns() function.

e.g 

Table2 =
SELECTCOLUMNS ( FILTER ( Table1, [Y/N] = "Y" ), "a", [Column1], "b", [Column2] )

You can refer to the following link about the  function

SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.