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?

 

[JEC]

I don’t see the logic here, could you explain more?

Why+2?
Why +9? Etc..

 

[karmaimages]

The SLA is based off of the following:

Impact+Severity

For example:

If Impact = A and Severity = 1 the SLA = Logged Date + 2 Months
If Impact = S and Severity = 3 the SLA = Logged Date + 12 Months

 

[JEC]

Still don’t get it…

 

[karmaimages]

It's really not that difficult to understand I don't think

 

[JEC]

I don’t see the logic. There are still zero answers so I am not the only one

 

[karmaimages]

If you don't understand then why are you being irritating and replying!

 

[JEC]

Pff, this is not irritating. But ok, wait for someone else

 

[RoryA]

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

 

[Peter_SSs]

.. and how would we have known this from the post #1 information?

If Impact = S and Severity = 3 the SLA = Logged Date + 12 Months

What if Impact is S and Severity is 1, 2 or 4? .. or are they not possible?

Are there other Impact categories besides A, B, C, D and S?