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())
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