Forum Discussion
Helper IIIDelete duplicates or pivot using dax
I have this table where I calculate the column "new" using dax, adding the offer value for each week and center, as you can see, all the rows that repeat week and center have the same value. But I would like to pivot or eliminate duplicates, the problem is that when using power query it does not show the column that I have calculated.
| Center | week | offer | new |
| 1 | 21 | -22 | 220 |
| 1 | 21 | 242 | 220 |
| 3 | 22 | 0 | 20 |
| 3 | 22 | 20 | 20 |
So how can I have a table like this?
| Center | week | new |
| 1 | 21 | 220 |
| 3 | 22 | 20 |
Instead having complex transformation steps in power query. You could create a table using dax, this is also faster in terms of loading speed.
Table 2 = SUMMARIZE('Table (2)',[Center],[week],[new])Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
3 Replies
nicolasvcIs a column I calculated it doing something like this:
New= CALCULATE(SUM(Table[offer]),ALLEXCEPT(Table,Table[week],Table[Center]))
But I did it in DAX because I couldn't find a way to do it in power query.
Instead having complex transformation steps in power query. You could create a table using dax, this is also faster in terms of loading speed.
Table 2 = SUMMARIZE('Table (2)',[Center],[week],[new])Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
