Identify unique values through time

[diegotarquino]

Hello everybody, I hope you're all fine and in good health.

I haven't been able to achive what I´m looking for: I need to identify which codes are unique for all the the years in analysis, each year. Please allow me to clarify: let´s consider the first code (highligthed in yellow), I´ve put a mark (1) to show the year where the code appears, whereas a blank space means the code doesn´t appear in that year. In this case it only appears in 2019, meaning it´s unique AND is located in 2019.

The second code, for example, appears in 2019, 2020 and 2021, so it´s not unique. The third code from the bottom up only appear in 2021, so it´s unique AND is located in 2021.

Under this reasoning, I need to identify, for each year, those codes that are unique throught all 3 years. Maybe a measure would help here, something like filtering the codes by year AND by "unique", I´m not sure.

Thanks in advance for your help.

Diego 

[Ashish_Mathur]

Hi,

Please show the exact result that you are expecting.

[diegotarquino]

Thank you Ashish, @davehus already helped me out😀

Thank you for your interest in helping me.

Regards,

Diego

[davehus]

Hi @diegotarquino ,

Can you provide a sample of your data so that I can see the structure of it?

Did I help you today? Please accept my solution and hit the Kudos button.

[diegotarquino]

Absolutely, please feel free to check it out:

https://docs.google.com/spreadsheets/d/13T1nqCDKJZzYhUjQ1ppcJ4h60H6MSB8i/edit?usp=sharing&ouid=11331...

Thank you!

[davehus]

I have not access .:) 

[diegotarquino]

Wooops! I´m really sorry, please try this one:

https://docs.google.com/spreadsheets/d/13T1nqCDKJZzYhUjQ1ppcJ4h60H6MSB8i/edit?usp=sharing&ouid=11331...

[davehus · Accepted solution]

Hi @diegotarquino ,

See if the attached is what you need.

There is a measure that counts the distinct records per year and then a second one counts the unique records, so 1 occurrence in 3 years.

Did I help you today? Please accept my solution and hit the Kudos button.

[diegotarquino]

Thank you very much for your help, thanks to it I was able to solve the problem I had.

Best,

Diego