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.
Hello,
I have a datasource with dates for which users filled in the same survey and I want to filter out the results for users that have filled the survey on both dates. Example below. The only users that should be on the new table are User1 and User3 since they are the only ones that sent both surveys in March 2017 and March 2018.
How can I get this in PBI Desktop?
Thanks
J
Date | User |
Mar-17 | User1 |
Mar-18 | User1 |
Mar-17 | User2 |
Mar-17 | User3 |
Mar-18 | User3 |
Mar-18 | User 4 |
Solved! Go to Solution.
Hi @jagostinhoCT,
Since we can't see your real data. It is hard for us to guess where the issue is. So could you please share us your pbix file with One Drive or Google Drive if possible?
By the way, try to run the formula again by removing the .[Date]. See if it works for you.
Table Users = VAR Users = COUNTROWS(VALUES('PDF Printing'[Completion time])) RETURN FILTER( ALL('PDF Printing'[Name]), CALCULATE(DISTINCTCOUNT('PDF Printing'[Completion time]))=Users)
Thanks,
Xi Jin.
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 |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |