Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

auto increment column base on condition

Hi all,   I need to create a new column (Dax or PowerQuery) based on other column. This is my scenario     Country date Test Indice China 22/01/2020 0:00:00 548 2179 China 23/01/2020 0:00:00 64...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    Please try a new column like

     

    What you want = COUNTX(FILTER(data,[Country]=EARLIER([Country]) && [date]<=EARLIER([date]) && [Test]>0),[date] )+0

     

     

    File is attached after signature

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 

Please try a new column like

 

What you want = COUNTX(FILTER(data,[Country]=EARLIER([Country]) && [date]<=EARLIER([date]) && [Test]>0),[date] )+0

 

 

File is attached after signature

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks , works perfect.