Forum Discussion

souvikghosh98's avatar
souvikghosh98
New Member
1 year ago
Solved

Filled blank rows

In a Category column, 4000 rows are there with "M" and "F" values and 1000 rows are blank in that category column. paralally Name column which is filled with values with no blank rows. This Category ...
  • v-aatheeque's avatar
    1 year ago

    Hi souvikghosh98 ,
    Thanks for reaching out to the Microsoft Fabric Community forum.

    Omid_Motamedise  ToddChitt Thanks for your prompt response.
    In the dataset, we have a Category column that contains some blank rows. Here’s how we can handle these blanks using Power Query:

    If our response or a community member’s response addressed your query, please mark it as 'Accept Answer' and click 'Yes' if you found it helpful.

    If you have any further questions, feel free to reach out.
    Thank you for being a part of the Microsoft Fabric Community Forum!