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 variety of critera: Wordcount, service needed, department and type of material. I have odd results and only one of the max SLA get populated, the rest they do not seem to be matched, anyone would know why?

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.

3 Replies

  • Rupak_bi's avatar
    Rupak_bi
    Super User
    2 years ago

    please share sample data. and confrim whether all of the criteria has to match or any of the to be matched.

  • 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.