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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

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.

TheBishopEmpire's avatar
TheBishopEmpire
Frequent Visitor
5 years ago

This DAX formula worked for me. Ashish, could you explain the formula a bit further so that I can understand how the "EARLIER" functions work in this case? 

Thanks in advance. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    You are welcome.  The EARLIER() function can be understood as the value in the current row of the column specified in the EARLIER() function.