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

v-diye-msft's avatar
v-diye-msft
Community Support
5 years ago

Hi Anonymous 

 

Plz let me know if you'd like to get below one:

Measure = var a = COUNTROWS(FILTER(ALL('Table'),[Delivery notes]=MAX('Table'[Delivery notes])&&[Index]<=MAX('Table'[Index])))
return
IF(a =1 , MAX('Table'[Delivery notes]),BLANK())
Measure 2 = IF([Measure]=BLANK(),BLANK(),MAX('Table'[Liter]))

Pbix attached.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-diye-msft,

thank you for your reply.
With this solution I only get a table, right?, but what i need is a extra column with the delivery notes in my data.

Later i need to relate data to the new delivery note column.

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    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 v-diye-msft ,

       

      yes! that worked perfectly.
      Thank you very much, to all of you! 

       

      🎉

       

      Best regards