Forum Discussion

AmalrajRRD1's avatar
AmalrajRRD1
Helper II
8 years ago
Solved

Grouping values

Hi all,   I have sales data upto one  laks, I want to group the data like "<1000, 1000-5000", "5000-7000" and <7000.   How to do it in dax function? somebody help me on this ?   thanks
Tips and Tricks
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi AmalrajRRD1,

     

    Add calculated column with below DAX formual.

    Group =
IF (
    Table1[Sales] < 1000,
    "<=1000",
    IF (
        Table1[Sales] > 1000
            && Table1[Sales] <= 5000,
        "1000-5000",
        IF ( Table1[Sales] > 5000 && Table1[Sales] <= 7000, "5000-7000", ">7000" )
    )
)

    Alternatively, you can right click the [sales] field and choose "new group".

     

    Result.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi AmalrajRRD1,

 

Add calculated column with below DAX formual.

Group =
IF (
    Table1[Sales] < 1000,
    "<=1000",
    IF (
        Table1[Sales] > 1000
            && Table1[Sales] <= 5000,
        "1000-5000",
        IF ( Table1[Sales] > 5000 && Table1[Sales] <= 7000, "5000-7000", ">7000" )
    )
)

Alternatively, you can right click the [sales] field and choose "new group".

 

Result.

 

Best regards,

Yuliana Gu

  • AmalrajRRD1's avatar
    AmalrajRRD1
    Helper II
    8 years ago

    Thanks for your Reply.