Creating a new Date Column based on multiple criteria - PowerBI

karmaimages

Board Regular
Joined
Oct 1, 2009
Messages
112
Office Version
  1. 365
Platform
  1. Windows
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:



ImpactSeverityLogged DateSLA
A101/01/2023=Logged Date+2 months
A201/01/2023=Logged Date+2 months
A301/01/2023=Logged Date+2 months
A401/01/2023=Logged Date+2 months
B101/01/2023=Logged Date+9 months
B201/01/2023=Logged Date+9 months
B301/01/2023=Logged Date+9 months
B401/01/2023=Logged Date+9 months
D101/01/2023=Logged Date+9 months
D201/01/2023=Logged Date+9 months
C101/01/2023=Logged Date+12 months
C201/01/2023=Logged Date+12 months
C301/01/2023=Logged Date+12 months
C401/01/2023=Logged Date+12 months
D301/01/2023=Logged Date+12 months
D401/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?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
I don’t see the logic here, could you explain more?

Why+2?
Why +9? Etc..
 
Upvote 0
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
 
Upvote 0
I don’t see the logic. There are still zero answers so I am not the only one
 
Upvote 0
Pff, this is not irritating. But ok, wait for someone else
 
Upvote 0
It appears that impact D is the only case where severity is actually relevant - is that correct?
 
Upvote 0
.. 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?
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top