Forum Discussion

margheritamart's avatar
margheritamart
Frequent Visitor
2 years ago
Solved

Lookupvalue results missing

Hi all,   I have tried to create a Lookup between two tables. What I am trying to do is to determine what is the max amount of days that a project can take based on the SLA table. This SLA has a va...
LOOKUPVALUE
queries
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, margheritamart 

     

    You can try the following methods.

    Column:

    Max SLA = CALCULATE(MAX('SLA table'[Max SLA]),
FILTER('SLA table',[Department]=EARLIER('WordCountSummary per language'[Department])
                 &&[Service needed]=EARLIER('WordCountSummary per language'[Service type])
                 &&[Wordcount bands]=EARLIER('WordCountSummary per language'[Word Count Bands SLA])
                 &&[Document type]=EARLIER('WordCountSummary per language'[Material type])))

    If this does not solve your problem, please provide more data.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
2 years ago

Hi, margheritamart 

 

You can try the following methods.

Column:

Max SLA = CALCULATE(MAX('SLA table'[Max SLA]),
FILTER('SLA table',[Department]=EARLIER('WordCountSummary per language'[Department])
                 &&[Service needed]=EARLIER('WordCountSummary per language'[Service type])
                 &&[Wordcount bands]=EARLIER('WordCountSummary per language'[Word Count Bands SLA])
                 &&[Document type]=EARLIER('WordCountSummary per language'[Material type])))

If this does not solve your problem, please provide more data.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

margheritamart's avatar
margheritamart
Frequent Visitor
2 years ago

Thanks you Charlotte, it worked 🙂