RELATED Column with between condition

[srdjanmish]

Hi Guys,

I have an issue I need to solve and it is like this:

• In first table I have levels of, for example, expertise, based on point system, and it is like:

Level name	Minimum Value	Maximum Value
Level 1	0	999.99
Level 2	1000	2599.99
Level 3	2600	4999.99
Level 4	5000	999999.99

• In second table I have collected experience, per person, employee. It has simple Name and SUM of Points

I need some way to add third column to second table, and that column represents Level name, based on value of collected points, and that value belongs to scale in first table. I know how to make it in SQL, I know there is, always, function IF, but first table is dynamic (tomorrow there can be 6 levels), it changes per month...

Thanks in advance....

[v-juanli-msft]

Hi @srdjanmish 

srdjanmish's suggestion should be helpful.

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please feel free to let me know.

Best Regards

Maggie

[srdjanmish]

Hi,

I am in middle of transfering and modeling data for this example, and, as soon as I get to test it, I vil give feedback. I think this is OK, and it will work..

[az38 · Accepted solution]

Hi @srdjanmish 

try a new measure

Measure = 
calculate(
FIRSTNONBLANK('Table'[Level name];1);FILTER(ALL('Table');[YOURVALUE]>='Table'[Minimum Value] && [YOURVALUE]<='Table'[Maximum Value]
)

do not hesitate to give a kudo to useful posts and mark solutions as solution