cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors