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 dax.
Using power bi dax how can we write the query to fill down.

 

  • 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

3 Replies

  • Rajesh_Vodela's avatar
    Rajesh_Vodela
    New Member
    2 years ago

    MattB-Motive 
    Actually this question was asked in an interview. And i was not aware of this. So, i want to know the solution that how can we do this in dax

  • 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