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  please provide the data in text format not an image
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi vanessafvg,

     

    Sure, here it is.

     

    CreationTimeUTC.1User NameIndex
    8/1/2018 0:00B1
    8/1/2018 0:00B1
    8/1/2018 0:00B1
    8/1/2018 0:00B1
    8/1/2018 0:00B1
    11/26/2018 0:00D1
    11/26/2018 0:00D1
    11/26/2018 0:00D1
    1/16/2019 0:00D1
    1/16/2019 0:00D1
    3/20/2019 0:00D1
    • 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.