Forum Discussion

Vinnie's avatar
Vinnie
Icon for Helper I rankHelper I
3 years ago
Solved

Circular dependency in DAX column

Hi all,   I need help with a DAX column. Originally the column worked just fine but when I added some extra logic I got an error (circular dependency).   I am still trying to understand what a ci...
  • Vinnie's avatar
    Vinnie
    3 years ago

    I fixed this issue by adjusting the DAX statement for the DAX column DateMovedOutWorkingStock.

    I replaced 

     

    var dateinworkingstock = calculate(selectedvalue(File[DateInWorkingStock]))

     

    by:

     

    var dateinworkingstock = LOOKUPVALUE(File[DateInWorkingStock], File[ID], File[ID])

     

Vinnie's avatar
Vinnie
Icon for Helper I rankHelper I
3 years ago

I fixed this issue by adjusting the DAX statement for the DAX column DateMovedOutWorkingStock.

I replaced 

 

var dateinworkingstock = calculate(selectedvalue(File[DateInWorkingStock]))

 

by:

 

var dateinworkingstock = LOOKUPVALUE(File[DateInWorkingStock], File[ID], File[ID])