cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
twister8889
Helper V
Helper V

lookupvalue non related table

Hi guys,

 

I have two tables not related. In the first table, I have USER and your type, the second one table has the values from these types. I need to return the values from these types. how can do I do this?

Table1 
UserType
AType1
AType1
BType2
BType2
CType3
CType3
D 
D 

 

Table2  
TypeStartEnd
Type1010
Type21030
Type330-


Result to User B: measure = 10
I need to know, for example, for user B to return the Start value ( 10 ) to use this in my other measure to calculate how many times this occours for this user.

1 ACCEPTED SOLUTION
nvprasad
Solution Specialist
Solution Specialist

Hi twister8889,

 

You can use the below DAX to get the required result without any relationship.

 

startvalue = Lookup(Table2[Start],Table2[Type],Table1[Type])

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

 

View solution in original post

1 REPLY 1
nvprasad
Solution Specialist
Solution Specialist

Hi twister8889,

 

You can use the below DAX to get the required result without any relationship.

 

startvalue = Lookup(Table2[Start],Table2[Type],Table1[Type])

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

 

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors