Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak,
thank you for your reply.
Do i have to relate the Index column to my Delivery notes column?
How is a Index column working? 
I just created a Index column and tried your formula but the cells in the column with the formula are all blank.

 

You can see below what it looks like.

 

Einzelne LS = if(isblank(countx(filter('Alle Werte','Alle Werte'[Alle Lieferscheine] =earlier('Alle Werte'[Alle Lieferscheine]) && [Index] <=earlier([Index])),'Alle Werte'[Alle Lieferscheine])),'Alle Werte'[Alle Lieferscheine])