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 all! Love this community! I'm new here and to PowerBI!
I am trying to do something that I haven't quite seen in other support posts. I have data that is coming in via a Microsoft Form. It is connected to PowerBI Desktop via its associated Excel spreadsheet stored in Sharepoint.
What I am trying to do is "filter" out duplicate responses so that only the most recent submission of theirs visualizes. Here's an example of my data:
For example, I would only like Tom and Melissa's most recent submissions (based on completion time) to visualize. This data is live and will continue to grow/change with duplicate submissions, so I'm hoping there is a solution via Power Query or DAX to only have the most recent submission, including if they submit any future responses.
Thanks for any assistance!
Solved! Go to Solution.
Hi,
Please try this measure:
Check =
var a = IF(CALCULATE(COUNT('Table'[Name]),ALLEXCEPT('Table','Table'[Name]))>1,1,0)
return
IF(a=1,IF(MAX('Table'[Completion time])=CALCULATE(MAX('Table'[Completion time]),ALLEXCEPT('Table','Table'[Name])),0,1),0)
Then apply it to the original table visual and set Check=0, the result shows:
Here is my test pbix file:
Hope this can help.
Best Regards,
Giotto Zhi
Hi,
Please try this measure:
Check =
var a = IF(CALCULATE(COUNT('Table'[Name]),ALLEXCEPT('Table','Table'[Name]))>1,1,0)
return
IF(a=1,IF(MAX('Table'[Completion time])=CALCULATE(MAX('Table'[Completion time]),ALLEXCEPT('Table','Table'[Name])),0,1),0)
Then apply it to the original table visual and set Check=0, the result shows:
Here is my test pbix file:
Hope this can help.
Best Regards,
Giotto Zhi
I think you can try lastnonblankvalue, part of Feb 2020 release
https://docs.microsoft.com/en-us/dax/lastnonblankvalue-function-dax
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |