Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
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! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |