Forum Discussion

Marcoss's avatar
Marcoss
Frequent Visitor
2 years ago
Solved

Circular dependency DAX

Hello everyone,   I would like to calculate for each month the value of D' as the sum of A', B' and C', based on the inputs: Start (only for the first month), A' (for the first month equals "Start"...
Need Help
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

    Hello Marcoss,

    Try this DAX for A':

    A' = CALCULATE(FIRSTNONBLANKVALUE('Table (2)'[Month], [Start']), All())+CALCULATE(SUMX('Table (2)', 'Table (2)'[B]+'Table (2)'[C]), FILTER(ALL('Table (2)'), 'Table (2)'[Month]<max('Table (2)'[Month])))
     
    Thank You.
     
    Replace Table (2) with the table name.
ChiragGarg2512's avatar
ChiragGarg2512
Solution Sage
2 years ago

Hello Marcoss,

Try this DAX for A':

A' = CALCULATE(FIRSTNONBLANKVALUE('Table (2)'[Month], [Start']), All())+CALCULATE(SUMX('Table (2)', 'Table (2)'[B]+'Table (2)'[C]), FILTER(ALL('Table (2)'), 'Table (2)'[Month]<max('Table (2)'[Month])))
 
Thank You.
 
Replace Table (2) with the table name.