How to calculate distinct count in a period with a specific entry date

[Melissa__Bbck]

Hello,

Small question.

I have a table with sales per person & client, where I have a Month & Year. I also have a table of candidates that at a certain moment in time became 'Upskilled' as of this specific moment. I want to calculate the sales entry of those specific candidates based on the time when they became 'Officially Upskilled'. See screenshot what I would need, if anyone is able to help me out which DAX functions I need to use to do this 

[Melissa__Bbck · Accepted solution]

I was able to solve it with a calculated colomn 🙂

So i'll try to remove my question.

thanks for the attend to assist!

Kind regards,

Melissa

[v-henryk-mstf]

Hi @Melissa__Bbck ,

Thanks for your feedback.😀

Best regards,

Henry

[v-henryk-mstf]

Hi @Melissa__Bbck ,

The information you have provided is not making the problem clear to me. Then can you provide the relevant test data(with sensitive information removed) and screenshots of the expected results, so that I can answer them for you as soon as possible.
link：
How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Looking forward to your feedback.

Best Regards,
Henry