Forum Discussion

BGuttmann's avatar
BGuttmann
Regular Visitor
9 years ago

Circular Reference when using LOOKUP in DAX

Hi, I am trying to use something similar to a vlookup in dax and am not able to get it working.. I've attached an example workbook. In table "Sheet1" I have got a column named "BucketID" which ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi BGuttmann,

 

The example file from that link is empty. So, please post it again or provide screenshot of your sample data and expect result if possible.

 

Thanks,
Yuliana Gu

BGuttmann's avatar
BGuttmann
Regular Visitor
9 years ago

Hi, the worksheet is empty but the tables are in powerpivot

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi BGuttmann,

     

    When I used LookUpValue() function to return [Bucket Name] from BucketID table, I came across the same error: circle dependency. Then, after recreating data model, the error disappeared. So, please delete the data model, and add the resource tale into Power pivot model again to see whether the issue persists.

     

    By the way, the LookUpValue function returned blank in the new column [Bucket]. Please check your source data to ensure it is correct.

     

    Thanks,
    Yuliana Gu