cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EdsonGomes
Regular Visitor

BUSCAR INFORMAÇÃO EM OUTRA TABELA SEM RELAÇÃO.

Duvida PB.JPG

 

Olá pessoal, Na imagem acima tenho a tabela 1 e tabela 2.

Quero buscar as informações da coluna [nome] da tabela 2, e levar para a tabela 1.
quero que fique conforme exemplo abaixo.


TABELA 1 [VALORES] TABELA 2 [nome]
10 6 a 10
15 11 a 20
20 21 a 30
15 11 a 20
21 21 a 30
34 31 a 40


Isso e possível?

1 ACCEPTED SOLUTION
ERD
Responsive Resident
Responsive Resident

Hi @EdsonGomes ,

Try this DAX measure:

 

#GetName = 
VAR currentValue = SELECTEDVALUE('T'[Value])
RETURN
CALCULATE(VALUES('T'[Name]), FILTER('T', currentValue >= 'T'[Min] && currentValue <= 'T'[Max]))

 

ERD_0-1618989673674.png

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

View solution in original post

1 REPLY 1
ERD
Responsive Resident
Responsive Resident

Hi @EdsonGomes ,

Try this DAX measure:

 

#GetName = 
VAR currentValue = SELECTEDVALUE('T'[Value])
RETURN
CALCULATE(VALUES('T'[Name]), FILTER('T', currentValue >= 'T'[Min] && currentValue <= 'T'[Max]))

 

ERD_0-1618989673674.png

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

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