Solved: Replicate Excel MAXIFS condition in PowerBI

Anonymous · ‎12-21-2022

Hello !

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

themistoklis · ‎12-21-2022

@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 · ‎12-21-2022

@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

Replicate Excel MAXIFS condition in PowerBI