Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

More than one filter in RANKX

Hi,

 

Need help in adding 2 filters in RANKX and sorting by Date.

 

Column = RANKX (
FILTER (Table1, Table1[Topic] = EARLIER ( Table1[Topic] ) ), FILTER (Table1, Table1[ID] = EARLIER ( Table1[ID] ) )
Table1[Date].[Date],
ASC,DENSE
)

 

However , I get an error - he expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

 

Any way to fix this?

 

Thanks

Shirin

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    6 years ago

    Hi Anonymous 

     

    To combine multiple filter conditions we can use && or || operators

     

    Column =
RANKX (
    FILTER (
        Table1,
        Table1[Topic] = EARLIER ( Table1[Topic] )
            && [ID] = EARLIER ( Table1[ID] )
    ),
    Table1[Date].[Date],
    ,
    ASC,
    DENSE
)

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    6 years ago

    Hi Anonymous 

     

    To combine multiple filter conditions we can use && or || operators

     

    Column =
RANKX (
    FILTER (
        Table1,
        Table1[Topic] = EARLIER ( Table1[Topic] )
            && [ID] = EARLIER ( Table1[ID] )
    ),
    Table1[Date].[Date],
    ,
    ASC,
    DENSE
)