Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Determine if Within SLA or Out of SLA?

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"

 

Nelzkie09_0-1675424172800.png

 

1 ACCEPTED SOLUTION
SamInogic
Super User
Super User

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,

 

SamInogic_0-1675426092159.png


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

Service:  http://www.inogic.com/services/ 

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

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

View solution in original post

4 REPLIES 4
SamInogic
Super User
Super User

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,

 

SamInogic_0-1675426092159.png


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

Service:  http://www.inogic.com/services/ 

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

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/
Anonymous
Not applicable

i tried again. this is working now! thanks for your soultions! 🙂

Anonymous
Not applicable

Hellom I'm getting the error/s 😞

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?

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

Service:  http://www.inogic.com/services/ 

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

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors