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

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