Circular Reference when using LOOKUP in DAX

[BGuttmann]

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 is generated from a formula (from dates being completed or not --- giving me a string of 1's and 0's...) -- I am trying to take that string of numbers, and look it up from table "BucketID" --- by looking up the tableID and then providing the corresponding text.... (this output/formula will be in column "Bucket"

can anyone help me?

link to the example file is here : https://1drv.ms/f/s!AjKuL-NFEjPStGN8rFzGGUA-M4Ia

[v-yulgu-msft]

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]

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

[v-yulgu-msft]

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