Using Slicer or Dax to Independently Filter Three Separate Date Columns

[tlwest86]

I have three columns of dates which represent the completion dates for three different work actions.  I have already combined the three work actions into one visualization which show elapsed days for each action and then the total of all three.  The problem is my file goes back multiple years and I only need to filter on the dates from 10/01/2021 to 09/30/2022.  I have done this numerous times with the dates tables I created, but do not know how to slice three date columns at once, without picking up the information of the other two columns.  If I slice on Column 1 it will return the desired results for Column but will not pick up the desired results for the other two columns.  Is there a way to filter three separate date columns for one visualization to show dates regardless of what the other two columns are displaying?

[PaulDBrown]

See if this thread helps:

https://community.powerbi.com/t5/Desktop/Filter-two-tables-from-one-slicer-using-OR-logic/m-p/212663... 

[tlwest86]

I am not familiar with INTERSECT.  Will it work when all three columns are within the same table?

[v-easonf-msft]

Hi, @tlwest86 

Not fully sure what you mean. Do you mean you want to create three date columns that do not affect each other in the same table? If so, you may need to create additional date tables and mesures to replace the original date fields.

 

Please check my attachment for more details.

Best Regards,
Community Support Team _ Eason

[PaulDBrown]

INTERSECT returns the rows common to both tables contained within the expression. It will work with independent date tables for each of the columns.