topic Re: Filtered Table in DAX Commands and Tips

Filtered Table

EmiDelgadoE — Thu, 29 Sep 2022 23:46:14 GMT

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!

Re: Filtered Table

v-yadongf-msft — Fri, 30 Sep 2022 01:42:23 GMT

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.

Re: Filtered Table

tamerj1 — Fri, 30 Sep 2022 02:43:52 GMT

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 )