Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Summarize table by a specific value from a column

Is there a way using the Summarize function to only pull in a specified value from a column? Heres an example of what I'm trying to do.

Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous

     

    try this

     

    SummarizedTable =
SUMMARIZE (
    FILTER ( 'Table', 'Table'[Column1] = "a" ),
    'Table'[StartDate],
    'Table'[Column1]
)

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

1 Reply

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Anonymous

     

    try this

     

    SummarizedTable =
SUMMARIZE (
    FILTER ( 'Table', 'Table'[Column1] = "a" ),
    'Table'[StartDate],
    'Table'[Column1]
)

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.