Forum Discussion

Minseven's avatar
Minseven
Helper I
7 years ago

Group Measures

Hello,

 

I have this data:

 

What I want to achieve seems easy but I cannot find any solution...

I want to categorize the Months column (a measure!) as something similar to:

IF(Months<1,"<1M",

    IF(Months<3,"<3M","")

 

But it seems impossible. It is also imposible to Group a measure.

 

What about a similar VLOOKUP with approximation parameter? How is the best way to achieve this?

 

Thx

Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Minseven in the data example you showed, "Months" is a measure or column? You can always create a calculated column if "Months" is a column, if it is a measure then you can create another measure to group values together

    • Minseven's avatar
      Minseven
      Helper I
      7 years ago

      It's a measure.

       

      You mean something like:

      MeasureB = IF(Table[Months]<1,"<1M",">1M")
      but syntax is incorrect
      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Minseven what error are you getting? You don't need to provide table name with the measure but if you provide the table name, make sure measure is that table.