Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create new summary table

Hi,   I have a table of sites and various metrics, and I created a calculated column to define 'Query age'   What I need is a new table that summarise query age > 1 months for each site, i....
Need Help
Show and Tell
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    try to create a new table with the code below:

    Table =
    ADDCOLUMNS(
        VALUES(TableName[Site]),
        ">1 month",
       CALCULATE(
            COUNTROWS(
                FILTER(
                    TableName,
                    TableName[Query age] <>"<1 month"
                )
            )
        )  
    )
     
    I tried and it works like this:

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

try to create a new table with the code below:

Table =
ADDCOLUMNS(
    VALUES(TableName[Site]),
    ">1 month",
   CALCULATE(
        COUNTROWS(
            FILTER(
                TableName,
                TableName[Query age] <>"<1 month"
            )
        )
    )  
)
 
I tried and it works like this:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Brilliant - thank you 🙂

     

    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      Anonymous  You are welcome. Is it qualified as a solution to your question?