Categorize and label data based on a range

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

Hi,

Write this calculated column formula in the Data Table

=CALCULATE(FIRSTNONBLANK(limits[Account Type],1),FILTER(limits,limits[Lower cut-off]<=EARLIER(Data[Revenue of Customer Group])&&limits[Upper cut-off]>=EARLIER(Data[Revenue of Customer Group])))

Hope this helps.

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

Many thanks, Lydia