Forum Discussion
Count matching rows for each date comparing with previous date
Hi ,
i an new to PowerBI , I am trying to create a measure to count the id's if it is present in the previous date and Count Id's if not present in the previous date based on date slicer selection. Kindly help me on this.
Table1:
| Date | Id |
| 1/2/2021 | 3211 |
| 1/2/2021 | 4561 |
| 1/2/2021 | 3112 |
| 5/3/2021 | 4356 |
| 5/3/2021 | 3211 |
| 5/3/2021 | 4561 |
| 5/3/2021 | 3245 |
| 5/3/2021 | 3821 |
| 4/6/2021 | 5432 |
| 4/6/2021 | 3112 |
| 4/6/2021 | 3211 |
| 4/6/2021 | 3542 |
Slicer : Date
So, if slicer selects 5/3/2021 ,it should compare with 1/2/2021 and if slicer selects 4/6/2021 ,it compares with 5/3/2021.
Example: Slicer selected : 5/3/2021
Matching ID's count on 5/3/2021 =2 (Matched ID's =3211 & 4561)
Unmatching Id count on 5/3/2021 = 3
Unmatching Id count on 1/2/2021 =1
i have achieved with calculated column , since slicer is used . i need to create the measures for the above to change based on slicer selection. Kindly help me
2 Replies
- Ashish_Mathur
Super User
Hi lakshmanan,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
