Power Query - Enter date based on criteria of 3 other cells

[karmaimages]

Hi

I have a list of information in excel which I'd like to transform in Power Query along with some other quires in the workbook, the information is structured as follows:

Severity	Impact	Date logged	SLA
A	1	01/01/2022	=IF Severity = A then Date Logged+2 Months
B	1	01/01/2022	=IF Severity = B then Date logged + 9 Months
C	1	01/01/2022	= If Severity = C then Date logged + 12 Months
D	1	01/01/2022	=IF Severity = D & Impact = 1 then Date logged + 9 Months
D	2	01/01/2022	=IF Severity = D & Impact = 2 then Date logged + 9 Months
D	3	01/01/2022	=IF Severity = D & Impact = 3 then Date logged + 12 Months
D	4	01/01/2022	=IF Severity = D & Impact = 4 then Date logged + 12 Months

If there any way to perform the function required in the SLA column using Power Query and how would this be written so this applied to any new data pulled into the report?

Any help much appreciated.

Many Thanks

 

[Kerryx]

=if [Severity]="A" then Date.AddMonths([Date logged],2)
else if [Severity]="B" then Date.AddMonths([Date logged],9)
else if [Severity]="C" then Date.AddMonths([Date logged],12) 
else if([Severity]="D" and [Impact]<=2) then Date.AddMonths([Date logged],9) 
else if([Severity]="D" and [Impact] >2) then Date.AddMonths([Date logged],12) else "NADA"

 

[karmaimages]

Thank you this works perfectly!

 

[Kerryx]

Glad to help