Filtered Table

[EmiDelgadoE]

I want to filter a table if certain elements of two different columns are the same. For example, I have the following table

Date	Client	Orders	First Order Date
June 2022	A	22	April 2022
June 2022	B	23	June 2022
July 2022	C	33	May 2022
July 2022	D	67	July 2022
August 2022	A	24	April 2022
August 2022	C	50	May 2022

I want to get a table that only contains data if the values in the date column and date first order match, ie:

Date	Client	Orders	First Order Date
June 2022	B	23	June 2022
July 2022	D	67	July 2022

Thanks!

[tamerj1 · Accepted solution]

Hi @EmiDelgadoE 
Most probably the two date columns are comming from two different table and [Orders] is a measure. However, the same logic shall be applicable anyway. Please refer to attached file.

Filter Measure = 
VAR CurrentDate = SELECTEDVALUE ( 'Table'[Date] )
VAR OrderDate = SELECTEDVALUE ( 'Table'[First Order Date] )
RETURN
    IF ( 
        CurrentDate = OrderDate ,
        1
    )

[v-yadongf-msft]

Hi @EmiDelgadoE ,

This is my test table:

Please try following DAX to create a new table:

NewTable = FILTER('Table','Table'[Date] = 'Table'[First Order Date])

Best regards,

Yadong Fang

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