Create a calculated Column to have a predefined value

[ViralPatel212]

Hello,

I have a table where it ranks by dealers by Volume and Trade. I am trying to create a new column where it replaces the Dealers name with the word Dealer and keeps Barclays as Barclays. 

Vol is jus a measure to Sum up the Vol and Trades is Counting the trades from a table. 

Before: 

After: 

not sure if this is simple to do?

thanks

viral

[ronrsnfld · Accepted solution]

You don't show where the dealer numbers are coming from.

If you want to do exactly what you write "replaces the Dealers name with the word Dealer and keeps Barclays as Barclays. "  then you can use the Table.ReplaceValue function:

#"Replace Non-Barclays" = Table.ReplaceValue(
        #"Changed Type",
        each [Dealer],
        "Dealer",
        (x,y,z)=> if y <> "Barclays" then z else y,
        {"Dealer"})

If you need a number appended to the Dealer, you'll need to inform how that number is determined.

[lbendlin]

yes.  Be careful not to sort the "other"  dealers unless you want to risk de-anonymization.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...