Thursday, 21 July 2016

Labelling the last week in a series above threshold

How to label the last week in the series with the total "extra" sales above the threshold for those n weeks in a row as below.


Step 1:

 Find running sum of sales less the threshold.


Step 2: Create a calculation that says if the running sum of weeks is greater than 0 and the next bar is equal to 0, return the number. 



This will show the running total if the number is the last occurrence, but otherwise will show nothing. 

Step 3: 

Bring "Running Sales for Week Series Label" to Label. It displays the required output as below.





Thanks Guru's,
Prazval.ks




DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks