cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
misul Regular Visitor
Regular Visitor

Equivalent function of Tableau : group and replace

Hello PBI Community!

 

Is there a function in Power BI / Power Query to perform a similar function as below? 

 

There is a column with multiple versions of the same entry. And the aim is to categorise these into one category (by defining a logic such as - looking at the first 5 characters etc.

 

[Example column]= Sample, samplee, sampel1, sampleer, Apple, apple, appler, appel etc..

 

In Tableau, it seems possible to semi-manually group and replace. https://www.tableau.com/products/prep

 

Tableau Group and Replace.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Equivalent function of Tableau : group and replace

Hi @misul

function of Tableau : group and replace is similar to function of Power BI : Binning and Grouping.

Refer to this article, you could use "group" to categorise multiple items into one category.

Or if you want to do some data transformations, like grouping rows by number of fields, you could consider 

Grouping in Power Query

 

Best Regards

Maggie

 

 

4 REPLIES 4
Super User
Super User

Re: Equivalent function of Tableau : group and replace

You can do this via grouping in Power BI. You could semi-automate this by creating a calculated column that uses FIND or SEARCH to categorize rows.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


d_sandip59 Frequent Visitor
Frequent Visitor

Re: Equivalent function of Tableau : group and replace

Hi,

Can you briefely describe what do you mean by that? it is good to have screen shot for better understanding.

 

Thanks,

Sandip Ghosh

Super User
Super User

Re: Equivalent function of Tableau : group and replace

So, if you have a column that you want to do grouping on, in the Fields area, click the ellipses next to the column name and choose "New Group". You will get a dialog like this:

 

image.png

 

You can use this dialog to manually group values within the column so that all of those different columns appear in your groups when you use the group that is created instead of the column in your visuals.

 

Now, another way of doing this is to create a new column in your model that essentially does the grouping. This may work better for your scenario. You can write a DAX function to do this, perhaps something like the following:

 

Column = 
SWITCH(
    TRUE(),
    IF(SEARCH("P",[Category],,FALSE),TRUE,FALSE),"Group1",
    IF(SEARCH("D",[Category],,FALSE),TRUE,FALSE),"Group2",
    "Group3"
)

Then you can use this calculated column in your visual and your information will be grouped as you define it in the formula.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Equivalent function of Tableau : group and replace

Hi @misul

function of Tableau : group and replace is similar to function of Power BI : Binning and Grouping.

Refer to this article, you could use "group" to categorise multiple items into one category.

Or if you want to do some data transformations, like grouping rows by number of fields, you could consider 

Grouping in Power Query

 

Best Regards

Maggie