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.

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

I have provided very basic form of the data I have to work with.

 

 

 

  • 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?