Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to 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
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
@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
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
25 | |
21 | |
20 | |
14 | |
13 |
User | Count |
---|---|
43 | |
37 | |
25 | |
24 | |
23 |