DAX Fridays! #90: Understanding LOOKUPVALUES error

[@danielsiffredi8403]

Ruth , you are genious ... calculate(firstnonblank(with the filter( ... was all I needed to tackle the issue I had for days with lookupvalue . I'm soooooo happy ... mil gracias otra vez Ruth. no tienes idea de lo que me has enseñado con tus videos. Cuando vaya por Madrid te doy un abrazote!!!

[@CurbalEN]

Muchas gracias Daniel, pero estoy poco en Madrid ;) /Ruth

[@victormanueltamesperez9946]

at 6:07 you state either 4 or 5. Shouldn't it need to be 4 or 3, since both have same order and childid ?

[@andrecavasotero6234]

Excellent solution with a semi-additive function.

[@CurbalEN]

Thanks :) /Ruth

[@rafaelvargas585]

Hola Ruth. Muchas gracias por este video. Soy nuevo en PBI y no tenía idea cómo resolver casos que se me han presentado donde necesitaba buscar un valor en otra tabla, pero esa tabla tenía una llave primaria compuesta. Pensé que solo era posible si creaba una nueva columna en el modelo, como "OrderID+CountryID", para hacer la busqueda. En los universos de SAP BusinessObjects, las relaciones pueden tener más de una columna y esto era uno de mis retos principales al tratar de usar PBI. Saludos

[@CurbalEN]

Ah! Perfecto! Buen fin de semana :) /Ruth

[@KeepItSimpleOriginal]

Hi, what if I want to fetch all data and not just first or the last one. Please help

[@HarshNathani]

Thank You so much. Was stuck in a similar issue since the last 2 hrs. Great Video and how to combat the Lookup Error.

[@CurbalEN]

Cool that it helped :)

[@showerchan6149]

hi, just want to say thank you. I was reading the other post for similar thing but couldn't work. and saw your video and it worked perfectly

[@CurbalEN]

Wonderful!! Love it when my videos are useful ! /Ruth

[@DanielWeikert]

Hi Ruth. I got a question you migh help with. Considering DAX. Is there a good way to do an apples to apples comparison for running totals in certain ranges? e.g. We startet selling in Feb 2017 until jun 2018. Now I like to see the running total in comparison to last year but only feb17 to jun 17 vs. feb18 to jun18. Thanks

[@CurbalEN]

Hi Daniel, I am on vacation, would you mind asking in Athens Power bi community? /Ruth

[@op9249]

Stuck for 1 week, You saved me!

[@CurbalEN]

Yey!!

[@hamidbahari6588]

Tanks alot for all training Ruth! And how i can dynamic my local drive path such as (C,D,E,) for import multi file into power query?

[@CurbalEN]

Would you mind posting the question in the power bi community? Thanks! /Ruth

[@anupajayakody]

I have a scenario where data is there in the look up table, but generates blank values for some values only. What is the solution here??

[@raghuchetanvaidya]

This worked like a charm. Thanks for sharing!

[@CurbalEN]

Yey!!

[@srutis4453]

I have a query... I need to plot incidents monthly based on x asix for open, closed, new incidents where open, new have been taken from created date and closed incident has been taken from closed date.. How do u plot all these open, new and closed with monthly based.... Note : here monthly I have 2 columns one is created and one is closed how to take one month basis and plot above three parameters in powerbi..

[@kazan1723]

Sorry for asking, but I am using lookupvalue and it brings a blank value, but when I download the data and go to excel "Vlookup", works perfectly, what ma I doing wrong?

[@alexjones7270]

Is it possible to use a similar method where the value you are bringing in is not Numeric?

[@ThoNguyen-cp2uo]

I was stucked in this case too, thank you so much for all your video. Its help me so much

[@KeepItSimpleOriginal]

You explianed for 1st not null value from another table column, what if I want all child data, i.e all rows of the child and not just the 1st one. Please help, stuck since weeks n found your video while searching the answer.

[@excelparatodos2562]

Thank you for posting, you saved me

[@DH-yj4sk]

Such a lifesaver, thank you for posting!

[@CurbalEN]

😊

[@pahan95]

Super helpful ruth, I have a question on PQ, can you dynamically/ automatically create new tables/ sheets based on column contents

[@CurbalEN]

You should be able to , it depends on what you want to do exactly. Can you share the exact details in the power bi community? Thanks! /Ruth

[@suvajitmandal4682]

I am facing issue with LookupValue issue , I want to explain the issue is there a mail id i can reach you

[@Victor-ol1lo]

July update brings the desired many to many relationship.....Best regards....

[@CurbalEN]

This is a pre-recorded video! I have to look at the m2m and do a video about it :) /Ruth

[@josepromero1452]

Thanks Ruth! it will be very interesting to look how m2m manages this problem.

[@CurbalEN]

As soon as I am back from the holidays, I will make some videos on all the new updates :) /Ruth

[@brunapaschoalino3306]

THANK YOU SO MUCH!!!!

[@CurbalEN]

My pleasure 😊 /Ruth

[@surajkale5642]

Heyy thanks

[@GaryMillerUK]

This seems like you are making up as you go along. It's not one of your best videos.

[@CurbalEN]

Sometimes unexpected things happen when doing demos and I have two options: re-shoot it or leave it so others see a human doing things rather than a perfect script. This time I chose to leave it 🤷‍♀️