cancel
Showing results for
Did you mean:
New Member

## Evaluation by Ranges of 2 different tables and that shows the value of a field, if it is true?

Good afternoon, greetings to the entire community, I am new to Power Bi and I am adapting, in this case I have 2 tables, of which
I have to evaluate certain values ​​in range, I explain myself better:

In the First Table "CAPI_LogRouteJournalTrans" I have 2 values:

a. ETHNICORIGINGID

that must be evaluated and compared with the "HCMETHNICORIGINCOMPLEMENT" table, the values ​​to be evaluated are 3:

a.ETHNICORIGINGID
b.FROMVALUE
C.TOVALUE
D. VALUECLASIFICATION

AT THE FIRST TABLE IT IS NECESSARY TO EVALUATE THE POINTS a AND b, COMPARE THEM WITH THE RANGES OF FROMVALUE AND TOVALUE AND ETHNICORIGINID THEN SHOW ME ACCORDING TO THE RANGE THE FIELD D. VALUECLASSIFICATION

Please I need guidance, what kind of formula should I use? in order to have the desired results, many thanks in advance

1 ACCEPTED SOLUTION
Super User

@Eduran15 , You can have new column in table A

maxx(filter(Table2, table1[ETHNICORIGINGID]  = Table2[ETHNICORIGINGID] && table1[EFICIENCIATRABAJADOR]  >= Table2[FROMVALUE]  && table1[EFICIENCIATRABAJADOR]  <= Table2[TOVALUE]  ), Table1[VALUECLASIFICATION])

2 REPLIES 2
New Member

Thank you very much, I am attaching the result, honestly I am very impressed and surprised, I had been trying to do this for many days.
I did the power bi course but they didn't explain DAX to us in depth, could you please recommend a DAX course or some material that I can consult? Thank you again...

Super User

@Eduran15 , You can have new column in table A

maxx(filter(Table2, table1[ETHNICORIGINGID]  = Table2[ETHNICORIGINGID] && table1[EFICIENCIATRABAJADOR]  >= Table2[FROMVALUE]  && table1[EFICIENCIATRABAJADOR]  <= Table2[TOVALUE]  ), Table1[VALUECLASIFICATION])

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors