Is there an efficent way to filter a table instead of duplicating it and adding filter conditions ?

[EaglesTony]

Hi,

  I have a table that has thousands of records on it and want to keep it as is.

  I need to have another version of this table, but with filter conditions on it and was going to duplicate the first table and add the filters, but wasn't sure if this is the more effiicent way to go about this or should I add a reference or I could add a flag to the original table based on a if condition.

[sroy_16 · Accepted solution]

Hello @EaglesTony ,

Yes you can create a same but depends what is the datasource. If its a SQL data you can write a query to filter the data to get only the columns that you need.
However if the data source is a flat file then you can either use power Query but for that you need to duplicate the table and then use power Query to filter the data. Alternatively, you can use DAX to create a calculated table but creating a new blank table and then definbe your DAX measure. For e.g you can have something like this
FilteredTable =
FILTER(
OriginalTable,
[SomeColumn] = "SomeValue"
)
Hope this would solve your query if not you can elaborate about the data sources to give a more proper solution.

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.