Forum Discussion

Sican94's avatar
Sican94
New Member
3 years ago

Populate column with same value based on other column

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!

Need Help

2 Replies

  • Shaurya's avatar
    Shaurya
    Icon for Memorable Member rankMemorable Member
    3 years ago

    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's avatar
      Sican94
      New Member
      3 years ago

      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! 🙂