Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have issu using filter. This is what i have :
Location Date
PARIS | 2016 |
PARIS | 2017 |
LONDON | 2017 |
MADRID | 2016 |
NEW-YORK | 2016 |
I want to have a table where location is only in 2017 :
Location Date
LONDON | 2017 |
Thank you for your help
Solved! Go to Solution.
Hi @nooneliveforeva,
Would you like to try this formula in a New Table.
Result = FILTER ( 'SourceTable', 'SourceTable'[Year] = 2017 && ( NOT 'SourceTable'[City] IN CALCULATETABLE ( VALUES ( SourceTable[City] ), FILTER ( 'SourceTable', 'SourceTable'[Year] = 2016 ) ) ) )
Best Regards!
Dale
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |