Hi all, I have a table with employee, exam, date of exam and type of exam.I need to program the next exam for each employer. Each employer has to do a new exam past 1 year of the last. So, I use the data of exam and sum 12 moths to get a new data. Like exemple below: emplyerdate of examtypenext examLeonardo05/04/2024blood05/04/2025Rafael05/04/2022blood05/04/2023Rafael05/04/2023blood04/04/2024Rafael05/04/2024blood05/04/2025 My trouble is: I need the calculate the next Rafael's exam only based the last date.The correct result is:employeedate of examtypenext examLeonardo05/04/2024blood05/04/2025Rafael05/04/2022blood Rafael05/04/2023blood Rafael05/04/2024blood05/04/2025 How can I do it on Power BI? Sorry any mistake, I'm Brazilian and still learning english.

Helper I

2 years ago

Solved

HELP WITH DAX

Hi all,

I have a table with employee, exam, date of exam and type of exam.

I need to program the next exam for each employer. Each employer has to do a new exam past 1 year of the last.

So, I use the data of exam and sum 12 moths to get a new data. Like exemple below:

My trouble is: I need the calculate the next Rafael's exam only based the last date.

The correct result is:

How can I do it on Power BI?

Sorry any mistake, I'm Brazilian and still learning english.