Forum Discussion

Rajesh_Vodela's avatar
Rajesh_Vodela
New Member
2 years ago
Solved

Dax Question

I have a Input table(left table) which contains 2 columns named category and brand_name nad my output should be the right tableas shown in the image. I want to fill down the values in category using...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Rajesh_Vodela 

     

    Thank you very much for MattB-Motive  reply. Based on your description, I have created some dax to achieve the effect you are looking for. Following picture shows the effect of the display.

    DAX:

     

     

    Method 1 = 
SWITCH (
    'Table'[Brand_Name],
    "5-Star", "Chocolates",
    "Daily Milk", "Chocolates",
    "Perk", "Chocolates",
    "Eclair", "Chocolates",
    "GoodDay", "Biscuits",
    "Boost", "Biscuits",
    "Britannia", "Biscuits",
    BLANK ()
)

    Method 2 = 
VAR _category = 'Table'[Brand_Name]
VAR _chocolatesGroup = { "5-Star", "Daily Milk", "Perk", "Eclair" }
VAR _biscuitsGroup = { "Britannia", "GoodDay", "Boost" }
RETURN
    IF (
        _category IN _chocolatesGroup,
        "Chocolates",
        IF ( _category IN _biscuitsGroup, "Biscuits" )
    )

     

     

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Rajesh_Vodela 

 

Thank you very much for MattB-Motive  reply. Based on your description, I have created some dax to achieve the effect you are looking for. Following picture shows the effect of the display.

DAX:

 

 

Method 1 = 
SWITCH (
    'Table'[Brand_Name],
    "5-Star", "Chocolates",
    "Daily Milk", "Chocolates",
    "Perk", "Chocolates",
    "Eclair", "Chocolates",
    "GoodDay", "Biscuits",
    "Boost", "Biscuits",
    "Britannia", "Biscuits",
    BLANK ()
)

Method 2 = 
VAR _category = 'Table'[Brand_Name]
VAR _chocolatesGroup = { "5-Star", "Daily Milk", "Perk", "Eclair" }
VAR _biscuitsGroup = { "Britannia", "GoodDay", "Boost" }
RETURN
    IF (
        _category IN _chocolatesGroup,
        "Chocolates",
        IF ( _category IN _biscuitsGroup, "Biscuits" )
    )

 

 

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum