How to create autonumber field when my field is blank?

[Anonymous]

Hello, i need your help for create a new column, this column should be a column incremental when the field is blank or empty. This dax generate a column when the field is not empty, i need the viceversa.

Columna = If(TechSynergies[ID]<>BLANK(), CALCULATE(

COUNTROWS(TechSynergies),

FILTER(

TechSynergies,

'TechSynergies'[ID]<=EARLIER([ID]) && TechSynergies[ID]<>BLANK()

)

))

Best regards

[amitchandak]

@Anonymous , You need something that will allow you that.

If nothing add an index column https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Try a new column

if(isblank(TechSynergies[ID]),countx(filter(TechSynergies , [index] <=earlier([Index]) && isblank(TechSynergies[ID]) ),TechSynergies[ID]), blank())

or  a new column

countx(filter(TechSynergies , [index] <=earlier([Index]) && isblank(TechSynergies[ID]) ),TechSynergies[ID])

[Anonymous]

I applied these dax but the field show all values empty or blank.