I’ve got a issue that I need to solve in Power BI that I thought I’d (hopefully) enlist the forum members help. I’ve got a list of applications received each year (in my sample dataset, 20 per year for 2015-2019) where one person can submit more than one application each year. What I’d like to do is have a measure to return the count of unique persons within each year, so my desired output would be like this:
I can solve it in SQL, but cannot get the processed data into Power BI, only the raw data. I’d guess I’m missing something small, but haven’t seen the way forward yet. Any thoughts?