Need help with creation of a measure for a line chart.

[bhattyzlatan]

Hi ,

So there is a Line graph, where the x-axis is a date field called weekend (friday). In the Y-axis, I have to show 2 fields.

First field is called Resolved SLA%. The formula for getting this is 

Resolved SLA%= (if(SUM(vw1[Closed Tickets])=0,0,(SUM(vw1[Resolved Values])/SUM(vw1[Closed Tickets])))). 

So, for every weekend value, the graph shows the Resolved SLA% correctly.

Now, I need to create a new field, the resolved SLA% needs to be 5% higher than the existing resolved SLA%, but this increase in % will be only for last 3 weekends only as shown below. I need to show the % in line chart against the weekend dates.

Weekend = FORMAT( ('vw1'[created_date] - mod(vw1[created_date] -1,7)+5),"DD/MMM/YY")

weekend	Resolved SLA%	New Resolved SLA%
08-Mar-24	80%	80%
15-Mar-24	81%	81%
22-Mar-24	73%	73%
29-Mar-24	78%	83%
05-Apr-24	84%	89%
12-Apr-24	90%	95%

[bhattyzlatan]

@v-kongfanf-msft I am still facing the issue. I also keep getting thsi error - Circular dependencies in calculated columns

[bhattyzlatan]

Hi @v-kongfanf-msft , really appreciate your help in this regard. 

[bhattyzlatan]

I am getting this error when I used this formula. Weekend is again a column created from created date. Is this why I am seeing this error? 

[v-kongfanf-msft]

Hi  @bhattyzlatan ,

You can try formula like below:

New Resolved SLA%_ =
VAR LastThreeWeekends =
    TOPN ( 3, VALUES ( 'vw1'[weekend] ), 'vw1'[weekend], DESC )
VAR ResolvedSLAPercent = [Resolved SLA%]
RETURN
    IF (
        'vw1'[weekend] IN LastThreeWeekends,
        ResolvedSLAPercent + 0.05,
        ResolvedSLAPercent
    )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.