Forum Discussion
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...
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.
MEAlexander33 So if it is a matter of order, you will need to add an Index so you can identify "first". Otherwise, what is the criteria for how you would identify which is which?
Yes it is a matter of order. In my example, the first CAM identified for each time_key and store_id would be the store level acocunt and the second would the the G&A level account.