Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!
Solved! Go to Solution.
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
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