Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I need to select the ID value whenever it matches the value of the previous month.
ID | Name | T | Date | Check |
333 | Pedro | 30 | 01-01-2019 | |
1111 | Juan | 30 | 01-01-2019 | 1111 |
1111 | Diego | 30 | 01-02-2019 |
Thanks!
Solved! Go to Solution.
Thanks!
Hi @Anonymous ,
I have a little confused about your scenario.
ID Name T Date Check 333 Pedro 30 01-01-2019 1111 Juan 30 01-01-2019 1111 1111 Diego 30 01-02-2019
Is the Check column your desired output?
I need to select the ID value whenever it matches the value of the previous month.
Is this column T in sample data the value you mentioned as matched value?
Please explain your logic in more details. In addition, more sample data will help us understand your scenario better and get the solution quickly.
Best Regards,
Cherry
Thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |