Creating a new Date Column based on multiple criteria

Question

Hi,&nbsp;&nbsp;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:&nbsp;&nbsp;ImpactSeverityLogged DateSLAA101/01/2023=Logged Date+2 monthsA201/01/2023=Logged Date+2 monthsA301/01/2023=Logged Date+2 monthsA401/01/2023=Logged Date+2 monthsB101/01/2023=Logged Date+9 monthsB201/01/2023=Logged Date+9 monthsB301/01/2023=Logged Date+9 monthsB401/01/2023=Logged Date+9 monthsD101/01/2023=Logged Date+9 monthsD201/01/2023=Logged Date+9 monthsC101/01/2023=Logged Date+12 monthsC201/01/2023=Logged Date+12 monthsC301/01/2023=Logged Date+12 monthsC401/01/2023=Logged Date+12 monthsD301/01/2023=Logged Date+12 monthsD401/01/2023=Logged Date+12 months&nbsp;Would someone be able to help me work out how to add the SLA date based on the other 2 criteria?

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
Please try to create a new column with below dax formula:
SLA =
VAR _impact = [Impact]
VAR _sev = [Severity]
VAR _ld = [Logged Date]
VAR _year =
    YEAR ( _ld )
VAR _month =
    MONTH ( _ld )
VAR _day =
    DAY ( _ld )
VAR _val =
    SWITCH (
        TRUE (),
        _impact = "A", DATE ( _year, _month + 2, _day ),
        _impact = "B"
            || _impact = "D"
            &amp;&amp; _sev IN { 1, 2 }, DATE ( _year, _month + 9, _day ),
        _impact = "C"
            || _impact = "D"
            &amp;&amp; _sev IN { 3, 4 }, DATE ( _year, _month + 12, _day )
    )
RETURN
    _val

Please refer the attached .pbix file.
&nbsp;
Best regards,Community Support Team_Binbin YuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Creating a new Date Column based on multiple criteria

2 Replies

Related content

Sequential Order column based on multiple criteria

DAX FILTER with multiple criteria

Multiple Criteria Filter

Dynamic Filter creation based on multiple criteria

Creating a Column Multiple Criteria

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