topic Re: Evaluation by Ranges of 2 different tables and that shows the value of a field, if it is true? in DAX Commands and Tips

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

Anonymous — Thu, 18 Aug 2022 18:00:08 GMT

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
b. EFICIENCIATRABAJADOR

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

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

amitchandak — Fri, 19 Aug 2022 04:32:02 GMT

Anonymous , 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])

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

Anonymous — Fri, 19 Aug 2022 16:44:33 GMT

amitchandak

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...