topic Re: Dax Question in DAX Commands and Tips

Dax Question

Rajesh_Vodela — Thu, 28 Mar 2024 12:37:39 GMT

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.

Re: Dax Question

MattB-Motive — Thu, 28 Mar 2024 13:02:22 GMT

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.

Re: Dax Question

Rajesh_Vodela — Thu, 28 Mar 2024 14:23:41 GMT

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

Re: Dax Question

Anonymous — Mon, 01 Apr 2024 08:26:36 GMT

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