Trouble with lookup in DAX

[Guttmann1983]

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

 

[Guttmann1983]

I saw that someone replied to this but since all posts for the past day and a half were lost i obviously cant see it...

 

[Nick Chobotar]

Hello,

This is very weird. I have already posted the answer to this post.
I will do it again. Hopefully, it will not disappear this time.

In a nutshell, I am suggesting two DAX alternatives to EXCEL VLOOKUP. You can see them below.


BUCKET ID NAMES V.01 =
LOOKUPVALUE ( BucketID[Bucket Name], BucketID[BucketID], Sheet1[BucketID] )


BUCKET ID NAMES V.02 =
CALCULATE (
VALUES ( BucketID[Bucket Name] ),
FILTER ( BucketID, [BucketID] = Sheet1[BucketID] )
)



This particular example is having an additional complication since the LOOKUP search value is being generated by CALCULATE and this method throws in a circular dependency for both lookup methods used. I had to create a separate dummy table (Table2) and linked it with the principal source table (Sheet1) to break the circular dependency

Here is the example.

https://1drv.ms/x/s!AtVaiaKuHugAojUmkQlNtr4REOzg


Thank you, Nick -