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 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
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
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
Hi,
You may download my PBI file from here.
Hope this helps.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |