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 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

Need Help

3 Replies

  • 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