Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dax for Circular dependency

Hello All,  I have a table  Fiscal year Allocations Expenditure 2022 10 5 2023 20 2 2024 10 6 2025 25 7   i need to create 2 measure whic...
Need Help
Tips and Tricks
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You can use

Bal carry on =
VAR CurrentYear =
    SELECTEDVALUE ( 'Table'[Fiscal year] )
VAR Result =
    CALCULATE (
        SUMX ( 'Table', 'Table'[Allocations] - 'Table'[Expenditure] ),
        'Table'[Fiscal Year] < CurrentYear
    )
RETURN
    Result

and

Bal log =
VAR CurrentYear =
    SELECTEDVALUE ( 'Table'[Fiscal year] )
VAR Result =
    CALCULATE (
        SUMX ( 'Table', 'Table'[Allocations] - 'Table'[Expenditure] ),
        'Table'[Fiscal Year] <= CurrentYear
    )
RETURN
    Result