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

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi Anonymous ,


According to your needs and I did the following test, First create a date list as the judgment condition, then count the number of rows that meet the time range. Get the final result.

Column = 
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER (
        ALL ( 'Table' ),
        [Column 2] = 1
            && 'Table'[id] = EARLIER ( 'Table'[id] )
    )
)
Nbr Activities during this period by id = 
IF ( 'Table'[Column 2] = 0, 0, MAX ( 'Table'[Column] ) )

Here is the sample pbix file.

 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.