none
Powerpivot grouping

    Question

  • I would like to create a calculated column to group a table by field and set a value based on whether or not another field is true at least once.

    Input:

    Name   Value

    A          True

    A          True

    A          False

    B          True

    B          False

    C          False

    Output

    Name   IsTrueOnce

    A         True

    B         True

    C         False

    Cheers,

    Shay

    Thursday, July 11, 2013 1:17 AM

Answers

  • This could be a solution:

    =CONTAINS(Test,Test[Name],Test[Name],Test[Value],TRUE)


    Marco Russo http://ssasworkshop.com http://www.sqlbi.com http://sqlblog.com/blogs/marco_russo

    • Marked as answer by seamust Friday, July 12, 2013 5:34 PM
    Friday, July 12, 2013 7:58 AM

All replies

  • This could be a solution:

    =CONTAINS(Test,Test[Name],Test[Name],Test[Value],TRUE)


    Marco Russo http://ssasworkshop.com http://www.sqlbi.com http://sqlblog.com/blogs/marco_russo

    • Marked as answer by seamust Friday, July 12, 2013 5:34 PM
    Friday, July 12, 2013 7:58 AM
  • This worked great. Thanks.

    shay

    Friday, July 12, 2013 5:34 PM