topic Re: Determine if Within SLA or Out of SLA? in DAX Commands and Tips

Determine if Within SLA or Out of SLA?

Anonymous — Fri, 03 Feb 2023 11:40:27 GMT

Hi Kind People,

Need your help.

I'm having a hard time as well in getting the SLA if Within and if Out of SLA.

Requirement:

1. if TAT is equal or less than SLA, should be Tagged as "Within SLA"

2. if TAT is not equal or greater than SLA, should be tagged as "Out of SLA" and if TAT is Blank, should be tagged as well as "Out of SLA"

SamInogic — Fri, 03 Feb 2023 12:08:27 GMT

Hi Anonymous,

In Power BI Report, within your table create a column with below DAX expression:

Within Or Out? = If(ISBLANK('SLA Table'[TAT]), "Out Of SLA", IF(HOUR('SLA Table'[TAT]) <= 'SLA Table'[SLA], "Within SLA","Out Of SLA"))

Please refer to the below screenshot,

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/

Anonymous — Fri, 03 Feb 2023 12:27:31 GMT

Hellom I'm getting the error/s 😞

SamInogic — Fri, 03 Feb 2023 13:07:17 GMT

Hi Anonymous,

Can you provide screenshot or text of error message here?

Also, can you make sure the TAT column have data type as Long Time?