Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Columns Calculation add

Hello everybody,   I need your help to add a make a calculate columns for my table.  I have this kind of table, Where I want to add a new column "Activity between October 2020 and Decembre 2020" t...
General Comment
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous ,

     

    Activity between October 2020 and Decembre 2020 = if(isblank(countx(filter(Table, Table[ID] = earlier([ID) && [Date] >=date(2020,10,1) && [Date] <=date(2020,12,31)),[ID])), "No", "Yes")


    Nbr Activities during this period by id = countx(filter(Table, Table[ID] = earlier([ID) && [Date] >=date(2020,10,1) && [Date] <=date(2020,12,31)),[ID])+0

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,

 

Activity between October 2020 and Decembre 2020 = if(isblank(countx(filter(Table, Table[ID] = earlier([ID) && [Date] >=date(2020,10,1) && [Date] <=date(2020,12,31)),[ID])), "No", "Yes")


Nbr Activities during this period by id = countx(filter(Table, Table[ID] = earlier([ID) && [Date] >=date(2020,10,1) && [Date] <=date(2020,12,31)),[ID])+0