Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
)
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
)
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.
User | Count |
---|---|
56 | |
33 | |
18 | |
17 | |
15 |
User | Count |
---|---|
94 | |
84 | |
37 | |
22 | |
20 |