Creating a new Date Column based on multiple criteria - PowerBI

[karmaimages]

Hi,



I need to add SLA dates to a report, which change based on the severity and impact of the item logged, I have a table as below:

Impact	Severity	Logged Date	SLA
A	1	01/01/2023	=Logged Date+2 months
A	2	01/01/2023	=Logged Date+2 months
A	3	01/01/2023	=Logged Date+2 months
A	4	01/01/2023	=Logged Date+2 months
B	1	01/01/2023	=Logged Date+9 months
B	2	01/01/2023	=Logged Date+9 months
B	3	01/01/2023	=Logged Date+9 months
B	4	01/01/2023	=Logged Date+9 months
D	1	01/01/2023	=Logged Date+9 months
D	2	01/01/2023	=Logged Date+9 months
C	1	01/01/2023	=Logged Date+12 months
C	2	01/01/2023	=Logged Date+12 months
C	3	01/01/2023	=Logged Date+12 months
C	4	01/01/2023	=Logged Date+12 months
D	3	01/01/2023	=Logged Date+12 months
D	4	01/01/2023	=Logged Date+12 months

Would someone be able to help me work out how to add the SLA date based on the other 2 criteria?

 

[karmaimages]

The options shown are the only ones that apply, A - D and 1 - 4 for each letter. and each have an SLA calculated by the Logged Date + X months depending on what the Severity + Impact is

 

[karmaimages]

It appears that impact D is the only case where severity is actually relevant - is that correct?

That would be Correct

All A = 2 Months
All B = 9 Months
All C = 12 Months
D1 & D2 = 9 Months
D3 & D4 = 12 Months

 

[RoryA]

Then assuming those are the only possible values, you could add a custom column using the formula:

=if [Impact]="A" then Date.AddMonths([Logged Date],2) else if [Impact]="B" then Date.AddMonths([Logged Date],9) else if [Impact] = "C" then Date.AddMonths([Logged Date],12) else if [Severity] <3 then Date.AddMonths([Logged Date],9) else Date.AddMonths([Logged Date],12)