cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
YoussefN Frequent Visitor
Frequent Visitor

if function 3 conditions from different table

Hi,

 

I have two tables REFERENCE and CALL I want to add a conditional column to the table CALL with True and False based on three conditions. 2 of the conditions are in table CALLand 1 in TABLE REFERENCE.

 

The conditions are If the value of the field Nr. of work = 1 and the value of the field Nr of order = 1 and the field reference point in table REFERENCE = 70 then the value should be true and else FALSE

 

How can I do this?

 

Thanx in advance

 

ScreenHunter 296.jpgexample table

2 REPLIES 2
Super User
Super User

Re: if function 3 conditions from different table

Have a look at the LOOKUPVALUE function or RELATED or RELATEDTABLE.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team
Community Support Team

Re: if function 3 conditions from different table

HI @YoussefN,

 

You can try to use below measure:

result =
VAR _no =
    MAX ( tableCall[Order No.] )
VAR _work =
    MAX ( tableCall[Nr. of work] )
VAR _order =
    MAX ( tableCall[Nr of order] )
VAR related_point =
    LOOKUPVALUE ( TableReference[Reference point], TableReference[Oder No.], _no )
        + 0
RETURN
    IF ( related_point = 70 && _work = 1 && _order = 1, TRUE (), FALSE () )

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 60 members 1,113 guests
Please welcome our newest community members: