Group Measures

[Minseven]

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

[parry2k]

@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]

It's a measure.

You mean something like:

MeasureB = IF(Table[Months]<1,"<1M",">1M")

but syntax is incorrect

[parry2k]

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

[Minseven]

yes, I got the same error without the table name:

 

[v-yulgu-msft]

Hi @Minseven,

From the screenshot, I cannot find any syntax error in the formula. Please delete the measure and re-create it for a test. If possible, please share the sample .pbix file so that I can check for you. Do mask senssitive data before uploading.

Regards,

Yuliana Gu