Error while using LOOKUPVALUE function in PowerBI ? Watch this | MiTutorials

[@Akshita9614]

I was stuck in this error for 4 days and was completely exhausted when this video came as blessings from heaven.It worked.Thanks a trillion.I can finally celebrate Ganesh Chaturthi

[@MITutorials]

Have fun 🤩

[@anotherlostcause329]

Mind blown, good concept in case someone bumped into an error. Although I'm not looking for matching names, I'm actually trying to return a date. Appreciate the video for explaining that this cannot return non-distinct value!

[@gabrielavalos6658]

Era exactamente lo que estaba buscando. Muchísimas gracias. No te imaginas cuánto tiempo me has ahorrado ❤

[@aditipapu4098]

Thank u so so so much...I was completely blank after getting this error. God sent ur video to me when I was 😢

[@EricMaingiMulinge]

Thank you the video was simple, and easy to follow. It helped fixed the error I was having

[@kemilylauar7369]

Thank you very much. I needed this solution to perform a sum of multiple values.

[@crys1287]

Thank you so much!!! Saved me from hours of crying :)

[@shiwangagarwal5590]

Thank you sir, I was struggling for a long time 🙂

[@MITutorials]

Happy to help

[@nantheesh6724]

Exactly the one i was looking for. Thankyou so much.

[@natanlunardelli7736]

Helped me a lot, thanks for the content!

[@joelast8503]

You are the absolute best!!!

[@royjethoo2]

Thank you! Listen to step by step and it works! :D

[@dataanalyticstips]

Very Helpful! Thanks

[@shivkumarraju2853]

Thank you for this formula was really helped me

[@mateocarranza1896]

Agradezco mucho esta información, me ayudo enormemente con el reporte que estoy elaborando

[@rozashadiyarova4776]

thank you, you made my day

[@bisolaamondi1170]

Wow, thank you so much, you made my work easy

[@MITutorials]

You are welcome!

[@antoniogonzalez8507]

Exactly what I was looking for, thanks!

[@MITutorials]

Glad to hear it!

[@dougjones1639]

Helped me...thank you.

[@ayankulzhabayev4586]

Thank you a lot! I tried exactly the same formula with Calculate and Lastnonblank but without adding ALL to filter. Any chance you know why it's not worked without ALL

[@XuanNguyen-be6io]

Thank you very much. I can fix the issue.

[@viniscera-97]

Love u guy, thanks!

[@vivekganguru2713]

Will that also work for decimal values ? Or only for text

[@yvesjanvier8750]

Thank you for your help

[@seenumohan3413]

Nice formula, It helps., Can we write the LOOKUPVALUE function in a measure

[@MITutorials]

Yes you can!

[@ryansodhi1815]

I am not able to write the lookup value function in measure. In column calculation, I am able to do but in measure I am not able to put the table& col. Name in the 3rd category (Search Value)

[@lamborghinicalitodbz]

Thanks a lot my friend!😎

[@Andrey48490]

really helpful! Thanks

[@syedabadhrunnisa]

Hi, here your showing only 1 use case of taking the first name only from the column, but i would like to know if i want to take both the names which is repeated for same order id , how do you solve this, this will be helpful for me & others as well.

[@srithalsikaranam4670]

Hi, after typing this formula I get the value 1, Could you please help me with this ?

[@gilfaria8141]

Thanks!

[@shivanihandore4738]

Thank you so much!!

[@jqts6490]

Trying to compare two columns using the above, but when I use an If function and the columns match is says it doesn't match Can you explain what power bi is doing in the background to help me out with this please? I am comparing two dates FYSA

[@MITutorials]

Difficult to say what's happening without looking at the data.. Perhaps you can share the sample data vis a link ?

[@jqts6490]

@@MITutorials Unfortunately I can not. BUT I did figure something out. I created another calculated column and used the Date function and then inputted the first calculated columns for the year, month, day functions. This took off all the times

[@jqts6490]

@@MITutorials One more question. I did this Formula on another table and I get back 1 the number. IF I change the 1 in the formula to 6 or anything else it will give me that instead of the true value in the cell. is there a reason for this?

[@sumeetkeluskar5589]

i used this formula but not all the data was pulled out of 53000 4000 values was pulled if.i do the lookup( after removing duplicates) it is 17000

[@529deepaks]

If there are 3 different values to lookup, this logic will help to get the first value only, am I going right?

[@MITutorials]

Yes.

[@nehashahpatel1741]

Million thanks

[@ilovepowerbi811]

This solve my issue

[@shoaibrehman9988]

Hi this is fantastic solution, could you pls assist i want to lookup in my Fact Table from Dimension Table. I hv already unique customer name in Fact Table, and i want to check how many names are matching from Dimension Table where names occuring multiple time while it has relationship one to many Fact Table (Name) to Dimensions Table (Name) Could you pls assist

[@nikakalichava8012]

ty

[@8409055881085]

🥳