Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |