Forum Discussion

KristyP's avatar
KristyP
Icon for Helper I rankHelper I
3 years ago
Solved

DAX Calucation

Hi,   I have two related tables. I am trying to find a value in one table based on a range ( min & max) and a category from the first table. The value I require is in the second table, seperate col...
  • KristyP's avatar
    KristyP
    3 years ago

    Sure, I can do this tomorrow.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

KristyP 
Please try

Value =
MAXX (
    FILTER (
        Table2,
        Table2[Product Group] = Table1[Product Group]
            && Table2[Min Usage Range] <= Table1[Usage]
            && Table2[Max Usage Range] >= Table1[Usage]
    ),
    Table2[Value]
)
KristyP's avatar
KristyP
Icon for Helper I rankHelper I
3 years ago

My apologies, I misunderstood.

 

I have tried this, but getting this error:

DAX expression operations do not support comparing values of type text with values of type integer. Consider the VALUE or FORMAT function to convert one of the values.

 

I have changed the Usage and value to text for the moment, which worked. Just concerned how this affect other calculation moving forward. Is there a better way to do this?