Populate column with same value based on other column

[Sican94]

Hello, everyone!

I'm struggling to ensure a column always has the same value, depending on other column. To illustrate this better, I'm sharing the example below:

Above, you can see that on the last two records, the first column has a different value from the other ones. What can be done to ensure I always have the same value whenever I have '506362299' on the right column? I have several cases like this for different combinations, so is there any way to ensure this for all cases?

Thanks in advance!

[Shaurya]

Hi @Sican94,

You can create a new DAX table and filter out the rows that are not needed in it. You'll have to decide first, which value is supposed to be kept for a particula ID in the second column.

Let's say for example you want MAX value, then you can use:

New Table = SUMMARIZE('Table','Table'[Value],"ID",MAX('Table'[ID]))

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

[Sican94]

Hi Shaurya,

I don't want to filter rows out, I wanted to change the content of the column to ensure they all share the same value. Do you think that is feasible?

Thanks in advance for your help! 🙂