Removing repeated values in a table

[Anonymous]

i have a data like below image . other column has different value  i need to make the repeating year for same customer blank. is it possible 

[ryan_mayu]

@Anonymous 

maybe you can try to create an index column in pq

Then use DAX to create a column

Column = if(COUNTAX(FILTER('Table','Table'[Index]<=EARLIER('Table'[Index])&&'Table'[customer]=EARLIER('Table'[customer])&&'Table'[year]=EARLIER('Table'[year])),'Table'[Index])>1,blank(),'Table'[year])

[amitchandak · Accepted solution]

@Anonymous , you can create a column like

if([Rank]=1, [column1], blank())

[amitchandak]

@Anonymous , You can create a column Rank on Date and filter for 1

rank = ranx(filter(Table, [year]=earlier([Year])),[Date],,asc,dense)

// If needed add customer

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

[Anonymous]

@amitchandak  thank you for the support. Is ranking and filtering will be removing the rows , i need the year value as 2017 for the first row and then blank for the remaining repetition based on the customer.