Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
Instead having complex transformation steps in power query. You could create a table using dax, this is also faster in terms of loading speed.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Instead having complex transformation steps in power query. You could create a table using dax, this is also faster in terms of loading speed.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
HI @nicolasvc ,
I am not sure on the DAX expression that you have created.
Is it a column or a measure?
If OFFER is a column than create it in Power Query instead of using DAX. In that way you will be able to see that in Power Query and remove duplicates.
Thanks,
Pragati
Is 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.