Dax Question

[Rajesh_Vodela]

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 · Accepted solution]

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

[Rajesh_Vodela]

@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

[MattB-Motive]

Hi @Rajesh_Vodela 
Is there a reason you want to do this in DAX and not Power Query?

Power Query is one click, DAX will be complex.

Fill values in a column - Power Query | Microsoft Learn

Just make sure the 'empty' cells are null before filling.