Forum Discussion
Solved
A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp
Hi, I'm a newish user to PowerBI and struggling with a calculation. I'm effectively trying to do a SUMIF, but I know you can't do that within PowerBI. I want to show the sum of the value of all op...
GB74 , Formula like. Try formula like
Open Order Value due this month = Calculate(Sum('Sales Orders'[Value]),filter('Sales Orders','Sales Orders'[Delivery Month]='Sales Orders'[Current Month]))
Boa tarde, estou tentando usar a medida abaixo para me retornar a media de lançamentos nos últimos 3 meses.
_mMEDIA PRESTACAO =
VAR MaxData =
EOMONTH( MAX(fCT2[Data Lcto] ), 0)
VAR Meses3Atras =
EOMONTH( MaxData, -3) +1
VAR Media =
CALCULATE (
[_mVALOR REAL],
fCT2[_mVALOR REAL]< 0,
fCT2[Data Lcto] >= Meses3Atras,
fCT2[Data Lcto] <=MaxData
) / 3
RETURN
Media