Forum Discussion

DerMoe's avatar
DerMoe
Frequent Visitor
4 years ago
Solved

naturalleftouterjoin in Power BI Report Builder

Hi guys

I am currently working a lot with the Power Bi Report Builder and getting an overview of working with different datasets:

 

On one side I have the Entity Questionnaire with the field CompnayNew - here are all IDs of the companies listed which have requested a questionnaire.

Table Questionnaire : 

CompnayNewExampleField 
1TURE
1FALSE
1TRUE
2TRUE
2FALSE
3TRUE

Now I want to join the names from the entity Compnay

Table Compnay:

[entityId][companyName]
1Test A
2Test B
3Test C

 

- but my DAX skills are not enough.

 

 

(This one is not working...)

 

Can you help me on this short join. Thank you 🙂 

 

Greetings