Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

What would be the exact formula for this count function?

Hi,   I want to come up with a formula which aggregrates the number of creation times per person based on one day.        The column index is just 1. The second image shows that the...
Need Help
  • vanessafvg's avatar
    vanessafvg
    7 years ago
    Anonymous 
     
    create a calcualted column
    countfunction = CALCULATE(SUM(Table1[Index]), ALLEXCEPT(Table1, Table1[User Name], Table1[CreationTimeUTC.1]))
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
7 years ago
Anonymous 
 
create a calcualted column
countfunction = CALCULATE(SUM(Table1[Index]), ALLEXCEPT(Table1, Table1[User Name], Table1[CreationTimeUTC.1]))
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you! This worked.