Forum Discussion
Remove Duplicate from Aggregated Column
Hi, I have created a DAX column to calculate the aggregate by lane but now I want to remove duplicate rows from the table. Can you please suggest how to do that?
Hi ray1804 ,
//I realized later that this is a calculated table, please try nesting the DISTINCT() function on the outside of the table's expression.
1. You can select these columns.
2. Right-click and remove the duplicate.
result.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum