Forum Discussion

Ivancito111's avatar
Ivancito111
Resolver I
4 years ago
Solved

Help with a LOOKUPVALUE

Hello, sorry to bother you and thank you for taking the time to read my problem. Also excuse my English, I am using DeepL Translator. Well let's start. Today I was asked to use LOOKUPVALUE to searc...
General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
parry2k's avatar
parry2k
Super User
4 years ago

Ivancito111 or you can have small version of this:

 

Origen Lead = 
var __suborigen = 
    LOOKUPVALUE( modelov2[Welcome GUID],
                'modelov2'[Suborigen],
                'TodoIntranet'[lead_pilot])

return 
IF ( __suborigen == BLANK(),
   CALCULATE ( MAX ( 'LeadsV2'[Suuborigen] ), TOPN ( 1, Filter ( 'LeadsV2', 'LeadsV2'[eMail] = 'TodoIntranet'[cliente_mail] ), 'LeadsV2'[Date], DESC ) ) ,
   __suborigen 
)

 

✨ Follow us on LinkedIn

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Ivancito111's avatar
    Ivancito111
    Resolver I
    4 years ago

    Hi, thank you very much for your reply, this was the only way that worked for me. That's right, as I needed the minor date first, I changed it from DESC to ASC.

     

    Ivancito111