Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Categorize and label data based on a range

Hi, I would like to categorize customers by their annual revenue using a definition in a separate table. I assume it’s best done with a calculated column.   I use following formula now. =IF(AllA...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Create the AccountType column using DAX below in the AllAccounts table.

Account Type = CALCULATE(FIRSTNONBLANK(relatetable[Account type],relatetable[Account type]),FILTER(relatetable,relatetable[Lower cut-off]<=AllAccounts[Revenue of customer group]&&relatetable[Upper cut-off]>=AllAccounts[Revenue of customer group]))




Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Works! Now I need to find out why it works.

Many thanks, Lydia