Forum Discussion

Regular Visitor

2 years ago

Need help to resolve circular reference error

I have 4 calculation based on columns index, Allowance of hours (default is 10), Hours used, Credit Hours and Remaining. Remaining is calculated as : Allowance of hours - Hours used + Credit Hours ...

Anonymous

Not applicable

2 years ago

Hi pradnyagophane ,

The problem is with [Allowance of Hours], how you defined it, please check that its logic applies the values that still need to be calculated.

Best regards,
Community Support Team_ Scott Chang

Regular Visitor

2 years ago

Here I am placing the data and expected result (remianing column)

Index	Month	Allowance of Hours	Hours Used	Credit Hours	Remaining (or overage)
1	May-23	10	13.25	0	-3.25
2	Jun-23	10	32.75	0.75	-22
3	Jul-23	10	35.75	6	-19.75
4	Aug-23	10	7.25	0.5	3.25
5	Sep-23	13.25	7.25	1.5	7.5
6	Oct-23	17.5	36	3.5	-15
7	Nov-23	10	67.25	45.5	-11.75
8	Dec-23	10	14.5	5.25	0.75
9	Jan-24	10.75	0	0	10.75
10	Feb-24	20.75	34.5	10	-3.75
11	Mar-24	10	1.25	0	8.75
12	Apr-24	18.75	7.75	0	11
13	May-24	21	10.5	0	10.5
14	Jun-24	20.5	0	0	20.5
15	Jul-24	30.5	0	0	30.5

Allowance of hours calculation:

Remaining Calculation:

Result is remaining.

Remaining = Allowance of Hours (default is 10) + Remaing of previous month if the number is positive -Hours used + Credit hours.

Formula needed to apply in Power BI is to get correct remaining.

Anonymous
Not applicable
2 years ago
Hi pradnyagophane ,

This seems unachievable. Allowance of hours is used when calculating Remaining.To calculate Allowance of hours, you need to determine the positive or negative of Remaining.

Best regards,
Community Support Team_ Scott Chang