Forum Discussion
Copy unique Numbers
Hi, I got a problem. I have a table with a few columns. my table has more than 300.000 lines. In one column are delivery notes, many of them exist more than one time in the column. I want to ...
Hi Anonymous
Let me know whether this helps:
Column = var a = COUNTROWS(FILTER(ALL('Table'),[Delivery notes]=EARLIER('Table'[Delivery notes])&&[Index]<=EARLIER('Table'[Index]))) return IF(a =1 , 'Table'[Delivery notes],BLANK())Column 2 = IF([Column]=BLANK(),BLANK(),[Liter])
Anonymous Can you just add an Index column in Power Query Editor? Need something to define "previous"