Page 1 of 1

Calculate a column help

Posted: Thu Apr 26, 2018 11:00 pm
by gs0706
I want to populate each row of this table (NumDays) with the count of rows from this table that have the value of KEY1. I have this working by extrapolating the data from an additional table we added but I'd like to not have to do that. How do I do this?

Re: Calculate a column help

Posted: Sun Jul 01, 2018 6:06 pm
by andredl
Assuming your data table is called "NumDays", which is what I understand from your description, and that you want the frequency (count) of each value appearing in the column labelled "KEY1", which is again what I understand from your description, you can get this count in a calculated column, by writing

=CALCULATE(COUNT(NumDays[KEY1]),FILTER(NumDays,NumDays[KEY1]=EARLIER(NumDays[KEY1])))