Forum Discussion

sam_rea_02's avatar
sam_rea_02
Frequent Visitor
3 years ago
Solved

Need help on calculating running SL

  Hi All,   Good day. I need your help on what dax function or calculation I should use for me to be able to get the running SL. Below is my sample data   b    c    d     e   Time ...
Need Help
SamInogic's avatar
SamInogic
Super User
3 years ago

Hi sam_rea_02 ,

You can follow below steps to get this output within your table,

1. Create an Index column using Query editor as shown in the below screenshot,


2. Create a column with below DAX expression,


Calculated Data = 'Sample Data'[Calls Handled] * 'Sample Data'[  Interval]

3. Then create another column “Running SL with DAX expression,

Running SL = CALCULATE (

 SUM('Sample Data'[Calculated Data]),

    ALL ( 'Sample Data' ),

   'Sample Data'[Index] <= EARLIER ( 'Sample Data'[Index] )

)/CALCULATE (

    SUM ( 'Sample Data'[Calls Handled]),

    ALL ( 'Sample Data' ),

   'Sample Data'[Index] <= EARLIER ( 'Sample Data'[Index] )

)
Please refer to the below screenshot for output,

 

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at [email protected]

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

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

sam_rea_02's avatar
sam_rea_02
Frequent Visitor
3 years ago

Hi SamInogic ,

 

Thanks for answering. I have applied all the steps you have mention but the output is not correct.

Please see attached screenshot.