Forum Discussion

bhartsell's avatar
bhartsell
Frequent Visitor
9 years ago
Solved

Count per day in calculated table

I have two tables, one of which has logs that occur multiple times throughout the day, and the other is a Date table. They are connected through a relationship between the date columns.    I'm tryi...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi bhartsell,

     

    Now that you have connected the two tables through a one to many relationship based on “date”. Please try this formula to create a calculated column:


    CountRows = COUNTROWS(RELATEDTABLE(Table_Log))

     

    If you have any question, please feel free to ask.

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi bhartsell,

 

Now that you have connected the two tables through a one to many relationship based on “date”. Please try this formula to create a calculated column:


CountRows = COUNTROWS(RELATEDTABLE(Table_Log))

 

If you have any question, please feel free to ask.

 

Best regards,
Yuliana Gu