AVERAGEIFS in Power Bi

Anonymous · ‎04-30-2021

Hi everyone,

yet again i need a excel formula to work in power bi, but i dont know how to put in a averageifs formula in power bi

=AVERAGEIFS(WaitingTime;OrderIn;">="&I2-J2;OrderIn;"<="&I2-K1;Forecast/Order/Sample;"ORDER")

I2 is a date (Today's date)

J2 is 40

K2 is 7

I already have al the right columns that i need in power bi.

Does anybody knows how to put this formula in a power bi formula?

Bram

Greg_Deckler · ‎04-30-2021

@Anonymous I have catalogued Excel to DAX translations here:

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...