Missing Screening

[reast]

I have a list of people with ID's, Start Date, End Date, Month (which is the month their screening was given), Score (of screening). What I need to know every month is which people were active based on their start and end date, but did not have a screening. My table has multiple rows for each person because it has the score each month. 

I think it would be a Calculate with Allexcept, but I can't seem to get it to work. Thank you so much for your help!!

[reast]

Never mind. I figured out a work around. Thanks!

[v-yulgu-msft]

Hi @reast ,

Would you please kindly share your solution? It might benefit more users having similar problem.

Regards,

Yuliana Gu

[v-yulgu-msft]

Hi @reast ,

Please illustrate the requirement with sample data and desired output.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu