Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

SLA Calculation %

‎03-11-2019 09:10 AM

Hi there, 

 

Can you please support me with the following SLA calculation, given that it has two parts and somehow the functions I've experimented, don't seem to be correct: 

 

[% of leavers = 

Effective Start Date 

Effective End Date 

Filters: 

French <> A1, A2

Attrition Date = 
Attrition Code = Impact_1

 

DIVIDE 

 

AVERAGE Leavers

Effective Start Date 

Effective End Date 

]

Thank you! 

 

Message 1 of 4
427 Views
0
3 REPLIES 3
nsadams87xx
Helper III
Helper III

‎03-11-2019 10:42 AM

Do you have a sample data set?

Message 2 of 4
417 Views
0
Anonymous
Not applicable
In response to nsadams87xx

‎03-11-2019 01:06 PM

Unfortunately cant share, its on my clients environment. Apologies. 

Message 3 of 4
408 Views
0
nsadams87xx
Helper III
Helper III
In response to Anonymous

‎03-13-2019 07:52 AM

Can you describe what your columns are?

Message 4 of 4
394 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All