Forum Discussion

EmiDelgadoE's avatar
EmiDelgadoE
New Member
3 years ago
Solved

Filtered Table

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

DateClientOrdersFirst Order Date
June 2022A22April 2022
June 2022B23June 2022
July 2022C33May 2022
July 2022D67July 2022
August 2022A24April 2022
August 2022C50May 2022

 

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

DateClientOrdersFirst Order Date
June 2022B23June 2022
July 2022D67July 2022

 

Thanks!

  • tamerj1's avatar
    tamerj1
    3 years ago

    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
    )

     

2 Replies

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    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.

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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
    )