Forum Discussion
Calculated Column that matches current cloumn only
alawode Well, honestly, that makes no sense to me in terms of practical use. But, be that as it may, you would need an Index column or something that identifies "earlier" and "later" like a date field. Let's say you add an Index column to your table in Power Query Editor, then you could do this:
Customer 2 Column = VAR __Index = [Index] VAR __Customer = [Customer 1] VAR __MinIndex = MINX(FILTER('Table',[Customer]=__Customer),[Index]) RETURN IF(__Index = __MinIndex,[Customer 1],BLANK())
Hi Greg, here's the Sample data attached. Im trying to make sure that "Customer 2" column only has the values in "customer 1" column at all times, and the values should not be duplicated (should be distinct in "Column 2" even if it appears more than once in "Column 1").
Thanks
alawode I'm not quite following the use case for this, perhaps you just need to create a new table using the formula: DISTINCT('Table'[Column 1])
Greg_DecklerHi GReg sorry for th confusion, im simply try to create a column (not a whole table), from the old one (Customer 1), with only the unique values, and not the duplicates
alawode Well, honestly, that makes no sense to me in terms of practical use. But, be that as it may, you would need an Index column or something that identifies "earlier" and "later" like a date field. Let's say you add an Index column to your table in Power Query Editor, then you could do this:
Customer 2 Column = VAR __Index = [Index] VAR __Customer = [Customer 1] VAR __MinIndex = MINX(FILTER('Table',[Customer]=__Customer),[Index]) RETURN IF(__Index = __MinIndex,[Customer 1],BLANK())Greg_DecklerThanks a lot, this works