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.

Rupak_bi's avatar
Rupak_bi
Icon for Super User rankSuper 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.