Forum Discussion

krwalke's avatar
krwalke
Frequent Visitor
3 years ago
Solved

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) s...
Need Help
  • Shaurya's avatar
    Shaurya
    3 years ago

    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

Shaurya's avatar
Shaurya
Memorable Member
3 years ago

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