Lookupvalue results missing

[margheritamart]

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?

[v-zhangti · Accepted solution]

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]

Thanks you Charlotte, it worked 🙂

[Rupak_bi]

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