Forum Discussion
Advocate IIIdetect dublicates and attach a string to the second value
Hi qwertzuiop,
You can enter to query edit and 'fill down' on your category fields and add an index column to your table.
Fill values in a column - Power Query | Microsoft Docs
Add an index column - Power Query | Microsoft Docs
After these steps, you can back to the 'data view' side add calculate column with Dax expressions to check the current 'business unit', index field values to remark the raw or duplicate rows.Regards,
Xiaoxin Sheng
Hi qwertzuiop,
You can enter to query edit and 'fill down' on your category fields and add an index column to your table.
Fill values in a column - Power Query | Microsoft Docs
Add an index column - Power Query | Microsoft Docs
After these steps, you can back to the 'data view' side add calculate column with Dax expressions to check the current 'business unit', index field values to remark the raw or duplicate rows.
Regards,
Xiaoxin Sheng