Find a row by value between two columns

[rmocca]

Hi,

I hope you all doing great.

I tell you my problem.

I have a measure that returns de CPK of a data table.

I have another table with categories, like this:

Code	Min	Max
A	0	1
B	1	2
C	2	3

I need to make another measure that takes the current CPK value, and check the Code when the CPK is between Min and Max.

Is this possible?

Thanks in advance.

[mahoneypat · Accepted solution]

This measure will return the Code based on the CPK result.  It assumes there is no relationship to the Code table.

CPK Code = var thisCPK = [YourCPKMeasure]

return calculate(MIN(Code[Code]), Code[Min]<= thisCPK, Code[Max]>= thisCPK)

Regards,

Pat

[rmocca]

Your are correct, there is not relation with the Code table.

I'm going to try this and let you know