Best way to filter a table?

[Anonymous]

I have a table visual made up of multiples fields/columns from multiples linked tables. 

I need to filter the main tables by two seperate columnes (both of which are date values) (i.e. show clients that have a date within one column and no date within another).

I cannot seem to create a formula to filter the table by.

What is the best way to go about this?

[edhans]

Formulas/measures don't filter tables. Slicers and filters filter tables.

You could use CALCULATETABLE() with filters to create a new table filtered as you want.

[Anonymous]

Hi, thank you for the suggestion.

I would like to learn how to use CALCULATETABLE() to create a new table based upon my required fitlers. What is the best way to go about learning about going about this? I need to fitlers based upon anumber of columns, all of which are pulling from seperate (but linked) data tables.

@edhans 

[edhans · Accepted solution]

See this CALCULATETABLE() definition by SQLBI, and the Related Articles section at the bottom. You can set filters in CALCULATETABLE() on a number of columns. It is best if the data has relationships between the tables you are working on and not get involved in using TREATAS() on unrelated tables.