Forum Discussion

ViralPatel212's avatar
ViralPatel212
Resolver I
2 years ago
Solved

Create a calculated Column to have a predefined value

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.  V...
Need Help
Show and Tell
Tutorial Requests
  • ronrsnfld's avatar
    ronrsnfld
    2 years ago

    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's avatar
lbendlin
Super User
2 years ago

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-Forum/ba-p/963216

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/1447523