Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Replicate Excel MAXIFS condition in PowerBI

Hello !

How to replicate below MAXIFS excel formula in powerBi ?
=MAXIFS(L:L,A:A,A2)

Need Help
Show and Tell
  • themistoklis's avatar
    themistoklis
    3 years ago

    Anonymous 

     

    Try the following:

     

    MAX_SUBID = CALCULATE(MAX('Table'[Sub_ID ]), ALLEXCEPT('Table', 'Table'[ID]))

     

    -- Excel
    =MAXIFS(L:L,A:A,A2)
    L:L = Sub_ID

    A:A = ID

1 Reply

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous 

     

    Try the following:

     

    MAX_SUBID = CALCULATE(MAX('Table'[Sub_ID ]), ALLEXCEPT('Table', 'Table'[ID]))

     

    -- Excel
    =MAXIFS(L:L,A:A,A2)
    L:L = Sub_ID

    A:A = ID