cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srdjanmish
Helper I
Helper I

RELATED Column with between condition

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 nameMinimum ValueMaximum Value
Level 10999.99
Level 210002599.99
Level 326004999.99
Level 45000999999.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....

1 ACCEPTED SOLUTION
az38
Super User II
Super User II

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


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

View solution in original post

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

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

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
Super User II
Super User II

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


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

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors