Forum Discussion
Conditional Many to One Relationship Question
Hi Group,
I'm relatively new to Power BI, and am stuck on pulling just one specific value to return from a many to one relationship. My data set below (Table A - Many side of the relationship) shows each JobID having multiple Milestones, but not necessarily every Milestone. In a separate table (Table B - One side of the relationship) that the JobID is relationshipped with (Many to One), I'd like to show a true/false or some kind of output for only one specific Milestone - let's say 100.
So, if the JobID in Table A has a 100 Milestone, then True, else False.. for all JobIDs in Table B.
Table A:
Hopefully this makes sense and thanks for the help!
Hi krwalke,
Filter Table A first to create a new table that only has the IDs with a specific milestone.
Milestone IDs = FILTER('Table A','Table A'[Milestone]=100)Then create a flag in Table B that shows true or false based on the fact whether that ID is present in the filtered table or not.
Flag = IF(ISBLANK(LOOKUPVALUE('Milestone IDs'[Job ID],'Milestone IDs'[Job ID],'Table B'[Job ID])), "False", "True")Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
1 Reply
- Shaurya
Memorable Member
Hi krwalke,
Filter Table A first to create a new table that only has the IDs with a specific milestone.
Milestone IDs = FILTER('Table A','Table A'[Milestone]=100)Then create a flag in Table B that shows true or false based on the fact whether that ID is present in the filtered table or not.
Flag = IF(ISBLANK(LOOKUPVALUE('Milestone IDs'[Job ID],'Milestone IDs'[Job ID],'Table B'[Job ID])), "False", "True")Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI