Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Countifs multtiple tables

Hi,   I have 2 tables an in total 5 columns for the countifs function Table 1                 Table 2  Name                   Name Date                     Date Handled Mail          I want t...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi Anonymous,

     

    You could create a relationship of the two tables and create a calculated column with IF FUNCTION.

     

    Column =
IF (
    AND (
        'Table1'[Date] = RELATED ( 'Table2'[Date] ),
        'Table1'[Name] = RELATED ( 'Table2'[Name] )
    ),
    COUNT ( Table1[Handled Mail] ),
    BLANK ()
)

    If you need additional help, please share your data sample and your desired output.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Anonymous,

 

You could create a relationship of the two tables and create a calculated column with IF FUNCTION.

 

Column =
IF (
    AND (
        'Table1'[Date] = RELATED ( 'Table2'[Date] ),
        'Table1'[Name] = RELATED ( 'Table2'[Name] )
    ),
    COUNT ( Table1[Handled Mail] ),
    BLANK ()
)

If you need additional help, please share your data sample and your desired output.

 

Best Regards,

Cherry