Forum Discussion
DAX Formula
CurrentMonthAverageYield =
VAR CurrentDate = MAX('calender yield'[Date])
RETURN
CALCULATE(
AVERAGE('Production orders'[Qty in kg]),
FILTER(
'calender yield',
'calender yield'[Date] >= STARTOFMONTH(TODAY()) &&
'calender yield'[Date] <= ENDOFMONTH(TODAY())
)
)
When I try to create this formula to show the current month average yield I get red lines under "TODAY" and an error message: "Parameter is not the correct type".
When I try to create this formula to show the current month average yield I get red lines under "TODAY" and an error message: "Parameter is not the correct type".
Hi, Anonymous
You can't Pass scalar value to STARTOFMONTH function you need to provide column name
Try below measureCurrentMonthAverageYield = VAR CurrentDate = MAX('calender yield'[Date]) var Monthstart = eomonth(today(),-1)+1 var MonthEnd = eomonth(today(),0) RETURN CALCULATE( AVERAGE('Production orders'[Qty in kg]), FILTER( 'calender yield', 'calender yield'[Date] >= Monthstart && 'calender yield'[Date] <= MonthEnd ) )
2 Replies
Hi, Anonymous
You can't Pass scalar value to STARTOFMONTH function you need to provide column name
Try below measureCurrentMonthAverageYield = VAR CurrentDate = MAX('calender yield'[Date]) var Monthstart = eomonth(today(),-1)+1 var MonthEnd = eomonth(today(),0) RETURN CALCULATE( AVERAGE('Production orders'[Qty in kg]), FILTER( 'calender yield', 'calender yield'[Date] >= Monthstart && 'calender yield'[Date] <= MonthEnd ) )