Forum Discussion

MEAlexander33's avatar
MEAlexander33
New Member
3 years ago
Solved

Duplicated Values - Need Assistance

Hi all.     I am rather new with Power BI and have a quick question for you all.   I have a data set where in one column there are a couple of duplciated values.   It is a financial data set, where...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi MEAlexander33 ,

     

    You could add an index column group by the CAM column.

    1.Group by, select All rows in the option.

     

    2.Add a custom column to add the index.

    3.Expand the column and create a custom column to return store level or G&A.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi MEAlexander33 ,

 

You could add an index column group by the CAM column.

1.Group by, select All rows in the option.

 

2.Add a custom column to add the index.

3.Expand the column and create a custom column to return store level or G&A.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.